View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default formula for telephone numbers.

Do 3 replace, ctrl + h then in the find what box put (
leave the replace with empty

do the same with ) and -


--


Regards,


Peo Sjoblom


"biffula" wrote in message
oups.com...
I have a list of thousands of phone numbers. I have been trying
various formulas to no success. My phone numbers look like this:

(123)456-7890

and I need them to look like this:

1234567890

They are in columns. Thanks.