The opposite of concatenate

[wagshal]

Hi all,
i have this text in a cell: "black;blue;white;green"
i need to put each word (color) in a different cell, the catch is that the solution has to be generic, because i also want to apply it to cells with less words (colors) in them (i.e. black;white;red).

what do i do?

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.