SUBSTITUTE function

description:

Change a part of a string with another string.

 

syntax:

=SUBSTITUTE( textold_textnew_text[instance_num] )

 

required arguments:

text The text string to replace.
old_text The portion of text to replace.
new_text The new text string that is used to replace the old one.

 

optional arguments:

[instance_num] The text string to replace.