Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you remove phone format????
I have a list of phone number with phone format (###) ###-####. I need to
remove the phone format and replace existing numbers as text "##########" How do I do this please???? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove dashes from phone numbers in a spreadsheet | Excel Worksheet Functions | |||
How can I remove extra characters from a list- phone numbers in ex | Excel Worksheet Functions | |||
a formular to remove spaces in a numeric cell (Phone No) | Excel Worksheet Functions | |||
remove the ( ) & dashes from column of phone # | Excel Worksheet Functions | |||
How do you remove duplicate phone numbers in an Excel spreadsheet | Excel Discussion (Misc queries) |