| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to uniformerly format different phone numbers
Hi everyone,
I have a situation where a column contains phone numbers, but all numbers are written differently. Some have areas codes and some don't. For example: COLUMN A 5742229384 5593857382 2283018 2201929184 3324838 SEE -some have the area code listed, and some don't. Is there a way to format the entire column so they look like this: (574) 222-9384 (559) 385-7382 228-3018 (220) 192-9184 332-4838 I'm familiar with the input mask found in Format cells / special, but it doesn't give me the right results because some phone numbers don't have an area code. Can anyone help? Thanks so much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format phone numbers to look the same | Excel Discussion (Misc queries) | |||
| Phone number format on numbers with Extensions | Excel Worksheet Functions | |||
| How do I format phone numbers in excel? | Excel Discussion (Misc queries) | |||
| Format sequence for phone numbers? | Excel Discussion (Misc queries) | |||
| Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions | |||
Threaded Mode
