Forum Discussion
I need help creating a formula to call a random word from the Excel Dictionary
I have a need, at work, to create formula in Excel to call a random word from the Excel Dictionary. This word will need the first letter capitalized.
Basically, this will create a Random Word, which I will do twice, then I'll create a few random numbers and a symbol or two. I'll have these assigned a random number, then index them in that order. Basically, a passphrase generator.
I have the formulae to create everything but the random word, and it's stumping me. Please help!
As far as I know, there is no way to do that.
If you create a list of words in a column on a worksheet, you can use a formula to return a random word from that list.
1 Reply
As far as I know, there is no way to do that.
If you create a list of words in a column on a worksheet, you can use a formula to return a random word from that list.