Excel Function : SUBSTITUTE

Download now!

Excel Function : SUBSTITUTE




Substitutes new text for old text in a text string

Microsoft Excel Reference Page


Syntax and Description of the SUBSTITUTE Excel Function

. The following will find the first occurrence of the ^ and replace it with nothing. =SUBSTITUTE(A1,"^","") If you have multiple occurrences of ^ then you can replace all of them with nothing. =SUBSTITUTE(A1,"^","") You can also specify which occurrence of ^ to replace. =SUBSTITUTE(A1,"^","",2) This will replace the second occurrence of ^ with nothing.

About SUBSTITUTE Excel Function

The SUBSTITUTE function in Excel can be used to replace a character or set of characters in a string of text. The function takes the following arguments: =SUBSTITUTE(text, old_text, new_text, [instance_num]) Text is the string of text that you want to replace characters in. Old_text is the text that you want to replace. New_text is the text that you want to replace old_text with. Instance_num is an optional argument that specifies which instance of old_text you want to replace. If omitted, all instances of old_text are replaced.