Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2005

Tip: Looking for answers? Try searching our database.

Random password generator?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KennyS - 30 Jun 2005 19:03 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.