Excel Function : SUBSTITUTE

Download now!

Excel Function : SUBSTITUTE

Category

Text

Description

Substitutes new text for old text in a text string

Microsoft Excel Reference Page

https://support.office.com/en-us/article/SUBSTITUTE-function-6434944e-a904-4336-a9b0-1e58df3bc332

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.