Thread: Help with Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach
 
Posts: n/a
Default Help with Excel

Do Edit - Replace. In Find what, put "(". In the Replace it with space put
nothing at all. Click Replace All.
Do that with the ")" and the "_" as well.
If you end up with a space where you don't want it, do it again. This time
in Find What, put " ". Note that the quotes have a space between them.
Replace that with nothing at all. HTH Otto
"swi" wrote in message
...
how do I remove the ( ) & - from a list of phone #s (aprx 22K #s)...