Add space to phone no's

[Guest]

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

 

[Guest]

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

HTH
Jean-Guy

 

[Anne Troy]

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

 

[Guest]

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]

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/data_cleanup_tips_for_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Pete]

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