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.

Hi
Edit - Replace?

--
Regards
Frank Kabel
Frankfurt, Germany

"Chris" schrieb im Newsbeitrag
...
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.

Go to Edit: Replace

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


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=276393