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
Bookmarks