| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting phone numbers
I am trying to format 2,000+ phone numbers from this format: 555-555-5555 h
to (555) 555-5555. Can anyone help with a formula to include the parenthesis and remove the letter "h" at the end? Thanks, LMR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting phone numbers using Special or Custom ..Help!!!! | Excel Discussion (Misc queries) | |||
| automatic formatting phone numbers in excel | Excel Worksheet Functions | |||
| Formatting Phone Numbers with Periods | Excel Discussion (Misc queries) | |||
| When merging phone numbers do not keep formatting why? | Excel Worksheet Functions | |||
| Formatting Phone Numbers in a Merged Cells... | Excel Discussion (Misc queries) | |||
Threaded Mode
