Simply select the column that has hte phone numbers in it, go to Edit,
then Find...

In the Find window hit hte Replace button. This will allow you to
replace the "-" character with nothing.


--
doltish
------------------------------------------------------------------------
doltish's Profile: http://www.excelforum.com/member.php...o&userid=24799
View this thread: http://www.excelforum.com/showthread...hreadid=383576