| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Characters
I have multiple words with parenthesis on the beginning and at the end of the
word. Example (Paul), (John), (George), (Beatles), (Ringo). How do I just delete the parenthesis in the beginning and at the end of each word? Example Paul, John, George, Beatles, Ringo. The words are all in Column C in Excel 2002. I have over 10,000 words that this has to be done to. It would take a long time to do it one by one. I hope someone can help me, Thanks Vinny |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting Characters
Vinny
Select the names, choose Edit, Replace; in the replace what box type "(" without the quotes and click Replace All button. Repeat with the ")" character. Regards Peter "Vinny0128" wrote: I have multiple words with parenthesis on the beginning and at the end of the word. Example (Paul), (John), (George), (Beatles), (Ringo). How do I just delete the parenthesis in the beginning and at the end of each word? Example Paul, John, George, Beatles, Ringo. The words are all in Column C in Excel 2002. I have over 10,000 words that this has to be done to. It would take a long time to do it one by one. I hope someone can help me, Thanks Vinny |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting Characters
Thanks Billy
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows with 11+ characters. | Excel Worksheet Functions | |||
| Deleting rows with 11+ characters. | Excel Discussion (Misc queries) | |||
| Deleting characters that are not numbers | Excel Discussion (Misc queries) | |||
| Deleting Blank Characters in a Cell | Excel Discussion (Misc queries) | |||
| Deleting 3 Text characters from the right | Excel Worksheet Functions | |||
Linear Mode
