converting phone numbers in column

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

How could I convert the column with the phone numbers such
as (630) 469-5600 to 630-469-5600. If it's the phone with
an extension such as (630) 539-3100 223 I need to put the
extension into separate column.

Thanks
 
Don't know how to handle the extensions, but a custom number format
000-000-0000 will take care of the 10-digit numbers. Go to Format-Cells
Number tab.
 
Thanks, Richard.
But, I couldn't handle with it. I've entered into the
custom format 000-000-0000 (I also tried [<=999999999]###-
###-####). However, the data in a cell is not being
converted from (000) 000-0000 format to 000-000-0000
format.

Regards,

Alex
 
Sorry, I didn't say that when I'm re-entering the number
in a cell it appears with the correct 000-000-0000 format.
But, I cannot figure out how to convert the whole column
without re-entering the data.

Thanks
 
Alex

You could do this in two steps.

Edit>Replace
what: (
with: nothing

Edit>Replace
what: )
with: -

To break out the extensions, use Data>Text to Columns>Fixed Width and delete
all breaks but that after the phone number but before the extension.

Double-click on a break-line to eliminate it.

Gord Dibben Excel MVP
 
Thanks, Gord.
-----Original Message-----
Alex

You could do this in two steps.

Edit>Replace
what: (
with: nothing

Edit>Replace
what: )
with: -

To break out the extensions, use Data>Text to Columns>Fixed Width and delete
all breaks but that after the phone number but before the extension.

Double-click on a break-line to eliminate it.

Gord Dibben Excel MVP



.
Click to expand...
 
Back
Top