Hi everyone,
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).

is there any way to accomplish that without using VBA?