Text to columns question

[spanishj]

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

[Jim May]

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


"spanishj" <[email protected]> wrote
in message news:[email protected]:

> 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