Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
Sure, I can help you with that. Here are the steps to split the text into multiple columns using a common delimiter:
That's it! Your data should now be split into two columns based on the common delimiter.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
Combining text from multiple columns into 1 | Excel Discussion (Misc queries) | |||
splitting text to multiple columns | Excel Discussion (Misc queries) |