Formating cells
 

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

Formating cells
 

Why dont you use a control find then replace the "("," )", "-"

"Kenny M." wrote:


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

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