| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
