Split text into multiple columns using a common delimiter

My data in col A is as follows:

1*15
101268*6
101352*16
101513*11
10406*2
10406*37
10411*13
10411*7

I want to add two columns with the data preceding the * going into Col
B and the data following the * going into Col C. I can't use RIGHT or
LEFT because the data is not the same length. If someone knows a way to
do this, I'd certainly appreciate knowing how. Thanks in advance.

buffgirl71, have a look at Data, text to columns, post back if you need help
with it

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"buffgirl71" > wrote in message
ups.com...
> My data in col A is as follows:
>
> 1*15
> 101268*6
> 101352*16
> 101513*11
> 10406*2
> 10406*37
> 10411*13
> 10411*7
>
> I want to add two columns with the data preceding the * going into Col
> B and the data following the * going into Col C. I can't use RIGHT or
> LEFT because the data is not the same length. If someone knows a way to
> do this, I'd certainly appreciate knowing how. Thanks in advance.
>

Thank you - that works perfectly. I knew about that functionality...I
don't know why I didn't think of it. Brain f*rt I guess. Thanks!


Paul B wrote:
> buffgirl71, have a look at Data, text to columns, post back if you need help
> with it
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "buffgirl71" > wrote in message
> ups.com...
> > My data in col A is as follows:
> >
> > 1*15
> > 101268*6
> > 101352*16
> > 101513*11
> > 10406*2
> > 10406*37
> > 10411*13
> > 10411*7
> >
> > I want to add two columns with the data preceding the * going into Col
> > B and the data following the * going into Col C. I can't use RIGHT or
> > LEFT because the data is not the same length. If someone knows a way to
> > do this, I'd certainly appreciate knowing how. Thanks in advance.
> >

Your welcome, "Brain f*rt I guess" it happens More to me now
than days

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"buffgirl71" > wrote in message
oups.com...
> Thank you - that works perfectly. I knew about that functionality...I
> don't know why I didn't think of it. Brain f*rt I guess. Thanks!
>
>
> Paul B wrote:
> > buffgirl71, have a look at Data, text to columns, post back if you need
help
> > with it
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "buffgirl71" > wrote in message
> > ups.com...
> > > My data in col A is as follows:
> > >
> > > 1*15
> > > 101268*6
> > > 101352*16
> > > 101513*11
> > > 10406*2
> > > 10406*37
> > > 10411*13
> > > 10411*7
> > >
> > > I want to add two columns with the data preceding the * going into Col
> > > B and the data following the * going into Col C. I can't use RIGHT or
> > > LEFT because the data is not the same length. If someone knows a way
to
> > > do this, I'd certainly appreciate knowing how. Thanks in advance.
> > >
>