It depends. If the hyphens are due to cell formatting, just change the
format of the cells by going to Format--Cells and choose Text instead of
Phone number. If there are hyphens in the cells, just select the column and
hit Ctrl+H. Type a hyphen into the Find What box, and don't put anything in
the Replace with box, and hit Replace all.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"TJMAURO" wrote in message
...
I am trying to change data listed in a phone number style of 555-555-5555.
I
need to eliminate the "-" so that the cells look like this: 5555555555.
Thanks!