Format Telephone Cell Range

  • Thread starter Victor Costello
  • Start date
V

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.
 
D

Dave Peterson

Select the column and do a bunch of edit|replaces

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

(don't forget hyphens)
 
Top