removing ( ) and - from phone numbers

[Jesse Braswell]

is there an easy way to remove the non number characters from phone
numbers.
Remove the ( ) and the dash - ?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Frank Kabel]

Hi Jesse
one way (if A1 stores your tel. number)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),")",""),"(")

 

[Norman Harker]

Hi Jesse!

Use:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"(",""),")","")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Frank!

Back to Starbucks! You dropped off the end.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Frank!

Back to Starbucks! You dropped off the end.

no - now it's more the time for some whiskey
Frank

 

[Norman Harker]

Hi Frank!

Pop in, I've got a nice range of the Single Malts. Put it in coffee or
mix it other than with another measure and your dead!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Frank!

Pop in, I've got a nice range of the Single Malts. Put it in coffee or
mix it other than with another measure and your dead!

Hi Norman
the only thing allowed is to put some drops of Highland water into a
cask strength whiskey !!!!!!!!!
Saying this: I just opened my new Macallan <vbg>

Cheers
Frank

 

[Dave Peterson]

How about edit|replace (three times).

Then use a phone number format.

 

[GQC]

highlight the column ; go to Edit / Replace ;
Find what: (
Replace with (leave this area blank)
Replace All

do that with the " ) " and the " - "

gqc