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”