| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't allow a space in a cell...how to prevent? | Excel Discussion (Misc queries) | |||
| formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
| Phone Numbers Repeated | Excel Discussion (Misc queries) | |||
| insert a space in a phone #. change (123)456-7890 to (123) 456-78 | Excel Worksheet Functions | |||
| Phone Dialer | Excel Discussion (Misc queries) | |||
Linear Mode
