Convert phone numbers with dashes in them to just numbers

[J H]

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

Thanks. Jenny

 

[Don Guillett]

have a look in the help index for SUBSTITUTE

 

[Gord Dibben]

First check to see if they are formatted as Special>Telephone numbers.

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

Try Edit>Replace

what: -

with: nothing


Gord Dibben MS Excel MVP