Hi , I'm trying to separate a string of text (keywords) separated by comas into 2 cells. Trying to put the first 3 words in B2 and the remaining words into C2 (i.e.- separate words into another cell after the second comma occurs). Any help would be much appreciated. Example below
example:
A2 = red, blue, green, yellow, orange, purple, gray, tan
desired result
B2 =red, blue, green
C2 =yellow, orange, purple, gray, tan
thanks
Put this B2...
=LEFT(A2,FIND("xx",SUBSTITUTE(A2,",","xx",3))-1)
Then use this in C2...
=MID(SUBSTITUTE(A2,B2,""),3,99)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Enter this formula in B2 and pull it to the right
=TRIM(MID(SUBSTITUTE(SUBSTITUTE("|"&$A2,",","|",3),"|",REPT(" ",125)),125*COLUMNS($A:A),125))
Row\Col red, blue, green, yellow, orange, purple, gray, tan red, blue, green yellow, orange, purple, gray, tan
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
This works amazingly! thanks so much
..I just tried Alkey's as well. Both work . Thanks to you both!
You're welcome and thank you for the feedback!
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks