I want to make a word scramble for my Nephew.
Lacking a Scramble() function
I looked at Rand() and made no progress.
I would like to take the word in column A and have it scrambled in column B. Like so.
dragonfly gfoadryln
I would also like to do it with two words;
Ice Cream rmciaeec
And one last requirement; keep font formatting. One letter will be red in word or phrase, the red letters will spell a clue about the scrambled words. ie If you read down the column, the red letters might spell 'fun at the zoo'
Any ideas? I can't seem to find a way to scramble or shuffle the letters.....
Lacking a Scramble() function
I would like to take the word in column A and have it scrambled in column B. Like so.
dragonfly gfoadryln
I would also like to do it with two words;
Ice Cream rmciaeec
And one last requirement; keep font formatting. One letter will be red in word or phrase, the red letters will spell a clue about the scrambled words. ie If you read down the column, the red letters might spell 'fun at the zoo'
Any ideas? I can't seem to find a way to scramble or shuffle the letters.....