... 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
B1 = red, blue, light green, yellow
C1 = orange, dark purple, grey
any ideas? thanks