Re: Split text into multiple columns using a common delimiter
- From: "Paul B" <to_much_spam_to_list@xxxxxxxxxx>
- Date: Tue, 14 Nov 2006 18:47:47 -0500
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" <buffgirl71@xxxxxxxxxxx> wrote in message
news:1163547652.338743.29690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
.
- Follow-Ups:
- Re: Split text into multiple columns using a common delimiter
- From: buffgirl71
- Re: Split text into multiple columns using a common delimiter
- References:
- Split text into multiple columns using a common delimiter
- From: buffgirl71
- Split text into multiple columns using a common delimiter
- Prev by Date: Split text into multiple columns using a common delimiter
- Next by Date: Re: Split text into multiple columns using a common delimiter
- Previous by thread: Split text into multiple columns using a common delimiter
- Next by thread: Re: Split text into multiple columns using a common delimiter
- Index(es):
Relevant Pages
|
