Hi,
I need help with this problem. I have two columns one that lists phon
numbers and the other one that lists the count.
I could easily do a text to columns however, some of the numbers i
sequence are shown with a -. i.e.2095381654-1655.
Do you know of a macro or the code that I could use to solve thi
problem.
Thanks in advance,

Column 1: Numbers
2095381654-1655, 2095382304, 2095382555, 2095384761, 2095386204
2095386386
Column 2: Count Numbers 7

Jo

--
spanish
-----------------------------------------------------------------------
spanishj's Profile: http://www.excelforum.com/member.php...fo&userid=3580
View this thread: http://www.excelforum.com/showthread.php?threadid=55579