converting phone numbers in column

[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

 

[Richard O. Neville]

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.

 

[Alex]

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

 

[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

 

[Gord Dibben]

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

 

[Alex]

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



.