Random password generator?

[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

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.co...generator.html
but I haven't tried it!! There are laods out there, though.

Andy.

"KennyS" <[email protected]> wrote in message
news:[email protected]...
>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.]

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

"KennyS" <[email protected]> wrote in message
news:[email protected]...
>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]

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.

[jsummerbee]

I realize that this thread is ancient, however I was trying to do this myself and came up with a way to do this in a single cell after using info from several different questions.

=TEXTJOIN("",TRUE,CHAR(RANDARRAY(A2,1,33,126,TRUE)))

Put any number you want in A2 to set the password length

Note that this produces a password that contains; lower case, upper case, numbers, and special characters. All characters that it can output can be found on a standard UK QWERTY keyboard.

[AliGW]

Thanks for the additional solution.