Add space to phone no's
 

I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please

Add space to phone no's
 

Use a custom format like.... # ###### or 0 000000

HTH
Jean-Guy

"Paul K." wrote:

I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please

Add space to phone no's
 

Format--Cells, Custom and type 00000 000000
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Paul K." wrote in message
...
I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please

Add space to phone no's
 

I tried this already, but I thought that I would give it another go.
Unfortunately the numbers don't change, I have no security on the worksheet
and have read and write permissions. Any other ideas? Would be appreciated!
Paul K.

"Anne Troy" wrote:

Format--Cells, Custom and type 00000 000000
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Paul K." wrote in message
...
I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please

Add space to phone no's
 

Likely, then, they are formatted as text.
Format the cells as numbers, with that custom format.
If that doesn't work, see "Data Isn't Recognized..."
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Paul K." wrote in message
...
I tried this already, but I thought that I would give it another go.
Unfortunately the numbers don't change, I have no security on the
worksheet
and have read and write permissions. Any other ideas? Would be
appreciated!
Paul K.

"Anne Troy" wrote:

Format--Cells, Custom and type 00000 000000
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Paul K." wrote in message
...
I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please

Add space to phone no's
 

Hi Paul,

there should also be a leading zero if the call is to a landline or
mobile number, so you could do this at the same time using this
formula:

="0"&LEFT(A1,4)&" "&TRIM(RIGHT(A1,LEN(A1)-4))

assuming your numbers start in A1. Copy this formula down as necessary
- the first 5 characters (including the 0) will be separated by a space
from the rest of the number.

If you have overseas numbers ("00") or DQ numbers, the formula would
need to be modified.

Personally, I think phone numbers should be treated as text - you are
not likely to want to do any arithmetic on them!

Hope this helps.

Pete