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.
If you have multiple occurrences of
^ then you can replace all of them with nothing.
You can also specify which occurrence of
^ to replace.
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.