Excel SUBSTITUTE Function
Syntax
=SUBSTITUTE(text, old_text, new_text, [instance_num])
Description
Substitutes new text for old text in a text string.
Example Excel File
Enter your email to receive the example Excel file (link valid 24h).
Become a supporter
—
download instantly, no email