I have a range of formats:

(555)945-4646

555-255-6323

555.895.8543

1+555.895.5074

Generalyl I would like to get rid of all spaces, parentheses, period's and
1+, 1-, to have all the numbers appear like so:

555-456-8542





"Gord Dibben" wrote:

Post a sample of the various formats you currently have.

You will probably have to do some stripping or adding of characters or
spaces.

Examples................

250 248 6616

(250) 248 6616

(250) 248-6616

2502486616

What format would you like those changed to?


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 12:23:09 -0700, essex711
wrote:

If I have a dataset of phone numbers in excel that are not all in the same
format, is there an easy way to have them reformatted so that they are all
consistent in that coulmn?