| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I remove extra characters from a list- phone numbers in ex
I have a long list of phone numbers that I need formatted as just numbers,
with no characters or spaces? Is there a formula for this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I remove extra characters from a list- phone numbers inex
I think you might find it easier to apply Find & Replace (CTRL-H) a
few times - highlight the column with the phone numbers in, then CTRL- H, and: Find What: ( Replace with: leave blank Click Replace All. Then CTRL-H again: Find What: ) Replace with: leave blank Click Replace All. And again: Find What: <space Replace with: leave blank Click Replace All. And so on, until you have removed all the characters you want to. Hope this helps. Pete On Nov 28, 3:51 pm, Sarah HK <Sarah wrote: I have a long list of phone numbers that I need formatted as just numbers, with no characters or spaces? Is there a formula for this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I remove extra characters from a list- phone numbers in ex
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"( ",""),")","")," ",""),"-","")
"Sarah HK" wrote: I have a long list of phone numbers that I need formatted as just numbers, with no characters or spaces? Is there a formula for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify list of phone numbers in a column... | Excel Discussion (Misc queries) | |||
| How can I change a list of phone numbers into peoples names | New Users to Excel | |||
| How do you remove duplicate phone numbers in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions | |||
| How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
Linear Mode
