Format Telephone Cell Range

[Victor Costello]

I have a contact list with my telephone #'s starting in H9. I have the cells
formated in this row with the special telephone format option; however, when
my data entry person enterred the data, she didn't realize this so now I
have some formatted (###) ###-#### which is the special excel format and
some are formatted like she enterred them, ### ### ####. Is there a way to
make all of them the same format as the (###) one?

Thanks for you help.

 

[Dave Peterson]

Select the column and do a bunch of edit|replaces

replace: ( ) (spacebar)
with: (leave blank)
replace all

(don't forget hyphens)