SUBSTITUTE function


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.