SUBSTITUTE()
Syntax. SUBSTITUTE(text,old_text,new_text,instance_num)
Definition. The SUBSTITUTE() function replaces characters or strings with new text.
Arguments
text (required). The text or the reference to a cell containing text in which you want to substitute characters
old_text (required). The string you want to replace
new_text (required). The string you want to replace old_text with
instance_num (optional). Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that occurrence of old_text is replaced; otherwise, every instance of old_text is replaced.
Background. Use this function to replace a string of text with alternative text. The replacement can be for a single or for multiple instances. ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
