S Sarah HK Nov 28, 2007 #1 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?
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?
P Pete_UK Nov 28, 2007 #2 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
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
T Teethless mama Nov 28, 2007 #3 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")," ",""),"-","")
