Deleting Characters

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

Guest

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
 
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
 

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

Using Rank with ties and spliting the differance 6
CountU from an array - SUMPRODUCT, SUM(IF(...)), both? 3
SUMPRODUCT, SUM(IF(...), or some combination? 2
Error: Does not exist in the current context 2
Delete row if blank in a column 5
INDEX problem with cells of same value 2
How do I manipulate a string to collect the address from it? 1
Multiple text in range into single column 3

Back
Top