| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
telephone number format
Hi,
I have a spreadsheet of contacts, over 2000. The telephone numbers are in the format 09999 999999 or 09999999999 I would like them to be updated to +44(0)9999 999999 How can I accomplish this as a batch update? Regards John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
telephone number format
Can you select the cells having the phone nos?
if yes, then 1. find and replace the space between numbers with nothing 2. format the cells as CUSTOM with the format 44 (0) #### ###### -- Pl click the ''''Yes'''' button (if you see it - don''''t worry if you don''''t), if this answer was helpful. "John" wrote: Hi, I have a spreadsheet of contacts, over 2000. The telephone numbers are in the format 09999 999999 or 09999999999 I would like them to be updated to +44(0)9999 999999 How can I accomplish this as a batch update? Regards John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
telephone number format
perfect thanks
Regards John "Sheeloo" just remove all As... wrote in message ... Can you select the cells having the phone nos? if yes, then 1. find and replace the space between numbers with nothing 2. format the cells as CUSTOM with the format 44 (0) #### ###### -- Pl click the ''''Yes'''' button (if you see it - don''''t worry if you don''''t), if this answer was helpful. "John" wrote: Hi, I have a spreadsheet of contacts, over 2000. The telephone numbers are in the format 09999 999999 or 09999999999 I would like them to be updated to +44(0)9999 999999 How can I accomplish this as a batch update? Regards John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
telephone number format
On Sun, 12 Apr 2009 16:16:48 +0100, "John" wrote:
Hi, I have a spreadsheet of contacts, over 2000. The telephone numbers are in the format 09999 999999 or 09999999999 I would like them to be updated to +44(0)9999 999999 How can I accomplish this as a batch update? Regards John In an adjacent cell you could use this formula: =TEXT(SUBSTITUTE(A1," ",""),"""+44(""0"")""0000 000000") and fill down as far as required. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format to telephone number | Excel Discussion (Misc queries) | |||
| telephone number format change in Excel | Excel Worksheet Functions | |||
| custom telephone number format | Excel Discussion (Misc queries) | |||
| Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) | |||
| Telephone number format | Excel Discussion (Misc queries) | |||
![John[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
