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.
