Delete carrots

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete carrots in a string 2
Selecting a Keyword 3
Data entered from list automatically enters number in another cell 4
Database price updating 3
Count values from Pivot Table 11
functions/Formulas 6
selecting cells without certain value 3
criteria to filter and extract row data into separate worksheet 1

Back
Top