paranthesis removal

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

Guest

In downloading stock information the stock symbols are enclosed in
paranthesis. How can I remove the paranthesis for a long list of stock
symbols without having to use delete for each stock symbol?
Thanks
 
One way:

Edit/Replace Find what: ( Replace with:
Edit/Replace Find what: ) Replace with:

(i.e., the replace with's blank)
 
You must log in or register to reply here.

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

editing a hyperlink 2
Index-Match, with Like or some other Function 7
Excel changes spelling of word 2
Conditional Highlight 16
how to strip an individual symbol from each row in a column 1
MSN Stock Quote 1
What's the best way to set this formula up? 0
How do I count the number of alpha occurences in a range? 2

Back
Top