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
Andy - 30 Jun 2005 19:57 GMT
Hi Kenny
I certainly don't know how to do it! I would suggest using something off the
net designed to do it. Here's one I found on Yahoo:
http://www.folder-password-expert.com/password-generator.html
but I haven't tried it!! There are laods out there, though.
Andy.
>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. D. Allen Sr. - 30 Jun 2005 20:44 GMT
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
>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
Bucky - 30 Jun 2005 21:55 GMT
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.