ExcelBanter - Delete carrots in a string

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Delete carrots in a string (https://www.excelbanter.com/excel-worksheet-functions/5956-delete-carrots-string.html)

[email protected]

Delete carrots in a string

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?

Frank Kabel

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

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

Gord Dibben

Contract it out to Bugs Bunny?

Or EditReplace

What: ^(caret)

With: leave empty

Replace all.

Gord Dibben Excel MVP

On Mon, 8 Nov 2004 13:12:03 -0800, "
wrote:

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?

All times are GMT +1. The time now is 01:02 PM.