Thread: Formating cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JavyD JavyD is offline
external usenet poster
 
Posts: 26
Default 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