Formating cells
in an adjacent cell input
=SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")
copy down. Then copy this new column, EditPastespecialValue
then delete column A
--
HTH
Bob Phillips
"Kenny M." wrote in message
...
HI I have many cels which hold phone numbers like this:
(987) 876-545
(987) 876-545
...
(987) 876-545
I want to eliminate the symbols "( )" and "-"
There are more than 2000 rows so I dont want to do it by hand, any Sug?
thks
|