Add a charcater between numbers -

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

Currently I have a large spread sheet 38,000 lines that I need to add a -
between the phone number so the file can be uploaded to another system. I'm
working on excel 2003 and was wondering is there a formula that would allow
me to do this?

The current data looks like this 3145555555. I need it to look like this
314-555-5555

Any ideas?
 
If you want to change the data in addition to the format you might consider
this formula then copy the value to another cell.

=CONCATENATE(LEFT(A3,3),"-",MID(A3,4,3),"-",RIGHT(A3,4))
 
Hi,
If your phone number data starts in F2, put this in G2 and copy down.
=LEFT(F2,3)&"-"&MID(F2,4,3)&"-"&RIGHT(F2,4)
Then copy and paste the hyphenated data over the original data, and delete
the column G data.

Or, select the phone number column, and custom format with:
###-###-####

Regards - Dave.
 
Currently I have a large spread sheet 38,000 lines that I need to add a -
between the phone number so the file can be uploaded to another system. I'm
working on excel 2003 and was wondering is there a formula that would allow
me to do this?

The current data looks like this 3145555555. I need it to look like this
314-555-5555

Any ideas?
Click to expand...

This will work with phone numbers with or without area codes prepended:

=TEXT(A1,"[<=9999999]###-####;(###) ###-####")

--ron
 
Back
Top