removing ( ) and - from phone numbers

  • Thread starter Thread starter Jesse Braswell
  • Start date Start date
Hi Jesse
one way (if A1 stores your tel. number)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),")",""),"(")
 
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.
 
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.
 
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.
 
Norman said:
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!
Click to expand...

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
 
highlight the column ; go to Edit / Replace ;
Find what: (
Replace with (leave this area blank)
Replace All

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

gqc
 
Back
Top