Random password generator?

  • Thread starter Thread starter KennyS
  • Start date Start date
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
 
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
 
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.
 
Back
Top