Hi, I have multiple duplicate entries in a column in excel, eg each cell contains: dog, cat, horse, pig, monkey, sheep, fish
There are multiple cells per column containing different terms but they are all seperated by commas and a space, I want to scramble them so each cell contains the same terms but sorted in a random order, so the example up there would become horse, sheep, monkey, cat, fish, dog etc, is this possible does anyone know?
Thanks
There are multiple cells per column containing different terms but they are all seperated by commas and a space, I want to scramble them so each cell contains the same terms but sorted in a random order, so the example up there would become horse, sheep, monkey, cat, fish, dog etc, is this possible does anyone know?
Thanks