Replacing the Caret character in Excel 2010
Posted on 2013-01-25
Ok maybe it's just early but how do I do this?
I have a spreadsheet from a supplier that has several hundred instances like
Joe Smith ^^
I want to get rid of ^^
^ (function not valid)
^^ (function not valid)
~^ (function not valid) (I thought this should work)
~^~^ (function not valid) (I thought this should work)
/^/^ (Not found)
\^\^ (Not found)
NOW if I do a Find Next or Find All with ^^, I get results.
If I am on the first result and hit Replace the characters are replaced.
If I hit Replace All, I get the function not valid error.
So yes I could do find next, replace, find next replace.... but this sheet has way too many instances of this to do that.
I know this is because of the special superpowers of ^ in excel but surely there must be a way to escape the character??