View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
buffgirl71 buffgirl71 is offline
external usenet poster
 
Posts: 13
Default Split text into multiple columns using a common delimiter

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.