Need to Change Column of Telephone numbers to just 10 characters

[Guest]

Hi

I imported data from another program into excel. The telephone numbers are in the following format 333 333-3333. How do I change it to just having 10 digits without spaces of hyhens. I need it in this format to export to another system

Jen

 

[Peo Sjoblom]

Edit>replace find what -, leave replace with blank,
then replace again and this time put a space in the find what and replace
with nothing

--

Regards,

Peo Sjoblom

Hi ,

I imported data from another program into excel. The telephone numbers

are in the following format 333 333-3333. How do I change it to just having
10 digits without spaces of hyhens. I need it in this format to export to
another system.

 

[Don Guillett]

Have a look in HELP index for SUBSTITUTE

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi ,

I imported data from another program into excel. The telephone numbers

are in the following format 333 333-3333. How do I change it to just having
10 digits without spaces of hyhens. I need it in this format to export to
another system.