Shuffle words to appear to be random

Shuffle words to appear to be random

Hi , I'm trying to make some data look a little more 'human' by shuffling around some words/phrases. Each cell will always contain 4 words/phrases. I'd like to shuffle them to make them look random. The comma needs to be the deliminator because sometimes the term might be a 2 or 3 words phrase or term (like 'dark forest green' for example). I figure the easiest way is to split each word/phrase into it's own column/cell, then reconstruct them using a varied formula to create the shuffle effect ? I'm very open to trying a macro if some genius out there knows one. I use macros but cannot write them, so figured I'd try a formula approach first. Example file attached and quick example below. Any ideas would be appreciated - THANK YOU


Column A (given data): Column B (desired results):
red, blue, green, yellow blue, red, yellow, green
red, blue, green, yellow green, blue, red, yellow
red, blue, green, yellow red, yellow, green, blue
red, blue, green, yellow yellow, green, red, blue

Use VBA ...

Please Login or Register  to view this content.

Thanks Phuocam , but I installed a new module , added the VBA , but cannot run it.. (it does not appear when I go to TOOLS>MACROS) . How do I use it ?

This formula option may work for you.

Please Login or Register  to view this content.

*$B$2:$B$5 this is your desired result cells that are put into a single array and it chooses the permutation based on a random number.