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
|