Hello All!
I have this situation that i have some data (different length but comma separated) in one cell, say C3. C3 is like this: C3="dog;cat;snace;etc". I wanna split all these content within C3 into different rows. Like this:D4=dog, D5=cat, D6=snace etc..
Could you help me out!
Thanks
Pomolo
Last edited by VBA Noob; 11-30-2008 at 03:32 PM.
Would using the Data/Text to columns wizard be any help?
Regards
Mike
Try this
=MID($C$3,FIND(CHAR(1),SUBSTITUTE(SUBSTITUTE(";"&$C$3&";",";",CHAR(1),ROW(A1)),";",CHAR(2),ROW(A1))),
FIND(CHAR(2),SUBSTITUTE(SUBSTITUTE(";"&$C$3&";",";",CHAR(1),ROW(A1)),";",CHAR(2),ROW(A1)))-FIND(CHAR(1),SUBSTITUTE(SUBSTITUTE(";"&$C$3&";",";",CHAR(1),ROW(A1)),";",CHAR(2),ROW(A2)))-1)
and copy down
It is a vba script, sorry for not mention it..Originally Posted by Mikeopolo
You don't need to use VBA when Excel has built-in Functions to do the job
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Put this is D4And the CF function is
Please Login or Register to view this content.I like the DATA text to columns better, but this is for learning and pleasurePlease Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks