Need to Change Column of Telephone numbers to just 10 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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


Jennifer Leen said:
Hi ,

I imported data from another program into excel. The telephone numbers
Click to expand...
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.
 
Have a look in HELP index for SUBSTITUTE

--
Don Guillett
SalesAid Software
(e-mail address removed)
Jennifer Leen said:
Hi ,

I imported data from another program into excel. The telephone numbers
Click to expand...
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.
 
Back
Top