Convert phone numbers with dashes in them to just numbers
 

I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny

Convert phone numbers with dashes in them to just numbers
 

have a look in the help index for SUBSTITUTE


--
Don Guillett
SalesAid Software

"J H" wrote in message
...
I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny

Convert phone numbers with dashes in them to just numbers
 

First check to see if they are formatted as SpecialTelephone numbers.

If not.................

Try EditReplace

what: -

with: nothing


Gord Dibben MS Excel MVP

On Thu, 22 Jun 2006 17:47:01 -0700, J H wrote:

I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny