Delete carrots in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data that contains carrots and I need to delete all of the carrots.
The carrots are always at the front and end of the string and sometimes in
the middle. Here is an example of the row data:

^99213^
^9921326^
^8951226^2924626^

How do you delete the carrots?
 
Contract it out to Bugs Bunny?

Or Edit>Replace

What: ^(caret)

With: leave empty

Replace all.


Gord Dibben Excel MVP
 
Back
Top