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