SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2247526%22%20slang%3D%22en-US%22%3EI%20need%20help%20creating%20a%20formula%20to%20call%20a%20random%20word%20from%20the%20Excel%20Dictionary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2247526%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20need%2C%20at%20work%2C%20to%20create%20formula%20in%20Excel%20to%20call%20a%20random%20word%20from%20the%20Excel%20Dictionary.%26nbsp%3B%20This%20word%20will%20need%20the%20first%20letter%20capitalized.%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%2C%20this%20will%20create%20a%20Random%20Word%2C%20which%20I%20will%20do%20twice%2C%20then%20I'll%20create%20a%20few%20random%20numbers%20and%20a%20symbol%20or%20two.%26nbsp%3B%20I'll%20have%20these%20assigned%20a%20random%20number%2C%20then%20index%20them%20in%20that%20order.%26nbsp%3B%20Basically%2C%20a%20passphrase%20generator.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20formulae%20to%20create%20everything%20but%20the%20random%20word%2C%20and%20it's%20stumping%20me.%26nbsp%3B%20Please%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2247526%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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 (Occasional Visitor)
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.