Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
Saving to a network share without delete permssions | Excel Discussion (Misc queries) | |||
Delete carrots | Excel Worksheet Functions | |||
Delete contents of unprotected cells in workbook | Excel Worksheet Functions |