I have a column of 4000 phone numbers that are entered in several
different ways. Such as.

(222) 222-2222
(222)222-2222
222-222-2222
222 222 2222
2222222222

I have set up a helper sheet for converting data and need to make sure
they all all converted to a format of:

2222222222

How do I write a formula to remove the colons, spaces, and dashes


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=500784