How can I remove extra characters from a list- phone numbers in ex

S

Sarah HK

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

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

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")," ",""),"-","")
 
Top