description:
Change a part of a string with another string. |
syntax:
=SUBSTITUTE( text, old_text, new_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. |