Text to columns question
 

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

Text to columns question
 

Why not use the "-" as the delimiter when using the text to columns
wizard;
It would do (it seems) perfectly..


"spanishj" wrote
in message :

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

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

Joy


--
spanishj
------------------------------------------------------------------------
spanishj's Profile: http://www.excelforum.com/member.php...o&userid=35806
View this thread: http://www.excelforum.com/showthread...hreadid=555796