SOLVED

I need help creating a formula to call a random word from the Excel Dictionary

Copper Contributor

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!

1 Reply
best response confirmed by SilverlineBob (Copper Contributor)
Solution

@SilverlineBob 

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 best response

Accepted Solutions
best response confirmed by SilverlineBob (Copper Contributor)
Solution

@SilverlineBob 

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.

View solution in original post