Excel 07 Reformat Phone numbers in Text Fields 1

[PeterMoran]

Hi,

I have a spreadsheet with a column of phone numbers in text.

Most of the phone numbers are 8 digits long and I would like to insert a space after the first four digits.

Is it possible to use wildcards in Excel's Find and Replace?

eg:
98986014 or Karina Savy (daughter) 98983239

to be:
9898 6014 or Karina Savy (daughter) 9898 3239

Can I do this with Find and Replace in Excel, or do I need VBA code, and if so, how?

Thanks in advance.

Peter Moran

 

[Gavona]

thread68-1389028 probably has the answer for you.

thread68-1253790 has more about wildcards.

Or simply insert a helper column and use the function:
=REPLACE(A14,5,0," ")
Copy this column, Pastespecial, values then delete the original

Gavin

 

[PeterMoran]

Hi,

Thanks Gavin.

Have a Star.

I had not thought of the REPLACE Function which I will use.

The others are v interesting but may be a little esoteric for the situation.

It is a pity the wildcard code in Word was not copied for use in Excel as it is most powerful.

Regards,

Peter Moran