Split data string into 2 new cells after 4th occurrence of character

... In the working scenario , it's a comma. I'm basically trying to take a string of words/phrases separated by commas , and split them into 2 new cells in column B and C after the 4th comma occurs.


DATA EXAMPLE :

A1 = red, blue, light green, yellow, orange, dark purple, grey

desired results:

B1 = red, blue, light green, yellow

C1 = orange, dark purple, grey


any ideas? thanks

Try these...

B1:

=LEFT(A1,FIND("^",SUBSTITUTE(A1,",","^",4))-1)

C1:

=MID(A1,FIND("^",SUBSTITUTE(A1,",","^",4))+2,100)

You're welcome. Thanks for the feedback!