SUBSTITUTE Function Explained
The SUBSTITUTE Function in Microsoft Excel replaces existing text with new text in a provided string. It takes three arguments: text, old_text, and new_text. text is the text or cell reference containing the text to be replaced. old_text is the text to be replaced, and new_text is the text to replace it with. The function returns the modified string.
SUBSTITUTE Function Syntax
SUBSTITUTE(text, old_text, new_text, [instance_num])
- text: The text or reference to a cell containing text for which you want to substitute characters.
- old_text: The existing text you want to replace.
- new_text: The text you want to replace old_text with.
- instance_num: (optional) Specifies which occurrence of old_text you want to replace. If omitted, every instance of old_text will be replaced.