ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   paranthesis removal (https://www.excelbanter.com/excel-worksheet-functions/142448-paranthesis-removal.html)

RADM

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

JE McGimpsey

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



All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com