Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

Replacing the Caret character in Excel 2010

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 ^^

 I've tried

^ (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??
0
SidFishes
Asked:
SidFishes
  • 2
1 Solution
 
NBVCCommented:
I did a quick test and I can do a replace all....

Is it possible to post a sample piece of that workbook to test it on?
0
 
SidFishesAuthor Commented:
hmmm. that's very odd. I copied a block of affected rows into a new spreadsheet so I could post and was able to do the global replace.

Still doesn't work in the original document.

maybe a corrupt worksheet?
0
 
NBVCCommented:
Maybe try doing a copy of the whole worksheet, then paste special Values or Values and Number Formats.  Then try the replace...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now