Changing Phone Format

[Kevin]

Hello all,
I need to change an existing phone column from this format xxx.xxx.xxxx to
just the phone digits so that it can be properly imported into another
application. Can anyone help with a macro to do this, please? I have over
250 customer records and really don't want to re-enter them all. Thank you.

 

[JE McGimpsey]

Hello all,
I need to change an existing phone column from this format xxx.xxx.xxxx to
just the phone digits so that it can be properly imported into another
application. Can anyone help with a macro to do this, please? I have over
250 customer records and really don't want to re-enter them all. Thank you.

Assuming your phone numbers are entered as text (i.e., with the '.'s
entered in the cell rather than displayed with formatting), one way:

Select your phone numbers. Choose Edit/Replace:

Find what: .
Replace with: <leave blank>

Click Replace All.

 

[Kevin]

Arrrrrgggggh! Such a simple solution! Thank you very much; I must have been
brain dead. It worked perfectly.

Thanks again.