View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default paranthesis removal

One way:

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

(i.e., the replace with's blank)

In article ,
RADM wrote:

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