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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.