Hi
I have a column of phone numbers e.g. 1555-555-1212. What formula do I
use to change all the numbers to e.g. 15555551212


--
natei6
------------------------------------------------------------------------
natei6's Profile: http://www.excelforum.com/member.php...fo&userid=7185
View this thread: http://www.excelforum.com/showthread...hreadid=320282