Random password generator?

K

KennyS

I know how to generate a random NUMBER. I need to generate a random
PASSWORD. ie: 8characters, numerals & alpha. I'm guessing almost all of
you know how to do it. I'd appreciate your help.

Thanks.
Kenny
 
W

W. D. Allen Sr.

Assuming you need eight character passwords using the twenty six lower case
letters and ten numerals.
1. In a column/row enter the numbers from 1 to 36.
2. Write each letter or numeral in an adjacent column/row for a total of
36 cells.
3. Lay out eight cells to each contain a random number between 1 and 36
generated using the function "=RANDBETWEEN()"
4. adjacent to the above eight cells use "=LOOKUP()" to select the letter
or numeral corresponding to each of the above eight random numbers.
5. That combination of eight letters and numerals is the password,
generated from a set of 2.8 trillion distinct passwords.

WDA

end
 
B

Bucky

Note that you need to install the Analysis Tookpak to use RANDBETWEEN.
You can always use "=INT(range * RAND()) - offset", where "range" and
"offset" are variable.

Another way is to use the CHAR() function.

=CHAR(RANDBETWEEN(48,122))

The problem is that you will get some of the non-alphanumerics between
48 and 122. But just fill down for about 20 rows, and take the first 8
characters that fit your criteria.
 
Top