Changing Phone Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 07 Aug 2007 23:50 GMT

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.

Reply to this Message

JE McGimpsey - 08 Aug 2007 00:49 GMT

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

Reply to this Message

Kevin - 08 Aug 2007 01:56 GMT

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

Thanks again.

> > Hello all,
> > I need to change an existing phone column from this format xxx.xxx.xxxx to
[quoted text clipped - 11 lines]
>
> Click Replace All.

Reply to this Message

Mac Forum / Applications / Excel / August 2007

Changing Phone Format