SUBSTITUTE
Substitute part of text string with another within a given text.
Syntax of Excel Substitute formula:
=SUBSTITUTE(text,old_text,new_text,[instance_num])
In words:
=SUBSTITUTE(within this text, this text, with this text, [only this instance of text])
Instance number is optional in this formula. If not mentioned, Excel will replace all instances of old text with new text.
Examples of Excel Substitute formula
=SUBSTITUTE(“This Excel formula is Awesome”, “This”, “That”) will return
“That Excel formula is Awesome”