| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Dashes
I have about 4,000 cells in Excel 200 that have phone numbers formatted as
(123)456-7890. I would like to remove everything except the numbers so that they come out like 1234567890, what is a good way to do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a formula to remove dashes? | Excel Discussion (Misc queries) | |||
| Remove dashes from phone numbers in a spreadsheet | Excel Worksheet Functions | |||
| Why do the preceding zeros disappear when I remove dashes? | Excel Discussion (Misc queries) | |||
| how to remove dashes | Excel Worksheet Functions | |||
| remove the ( ) & dashes from column of phone # | Excel Worksheet Functions | |||
Threaded Mode
