Delete carrots

C

Chris

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

^99213^
^9921326^
^99453^9952126^

How can I delete all of the carrots? I appreciate the help.
 
K

kraljb

Go to Edit: Replace

In "Find what:" put ^
Leave "Replace with:" blank
Click Replace All, or go through each cell with Replace
 
Top