Formating cells

[Kenny M.]

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

[JavyD]

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
>

[Bob Phillips]

in an adjacent cell input

=SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")

copy down. Then copy this new column, Edit>Pastespecial>Value

then delete column A



--
HTH

Bob Phillips

"Kenny M." <KennyM@discussions.microsoft.com> wrote in message
news:C9C70051-531B-41FF-84EF-CA58E98E0E90@microsoft.com...
>
> 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
>