Generate a list of passwords with excel
mariposa
-
eriiic Posted messages 25847 Registration date Status Contributeur Last intervention -
eriiic Posted messages 25847 Registration date Status Contributeur Last intervention -
Hello,
I would like to generate a list of passwords with an identifier. I then need to send them by email to their recipients so they can sign up for a directory.
I have no knowledge of computers. Maybe there is a solution with Excel?
The password must contain 3 uppercase letters, numbers, and 3 lowercase letters.
Example: AAA15aaa
Thank you in advance for the help you will provide me.
Configuration: Windows 7 / Firefox 6.0.2
I would like to generate a list of passwords with an identifier. I then need to send them by email to their recipients so they can sign up for a directory.
I have no knowledge of computers. Maybe there is a solution with Excel?
The password must contain 3 uppercase letters, numbers, and 3 lowercase letters.
Example: AAA15aaa
Thank you in advance for the help you will provide me.
Configuration: Windows 7 / Firefox 6.0.2
2 answers
Hello,
in A1:
=CHAR(RAND()*26+65)&CHAR(RAND()*26+65)&CHAR(RAND()*26+65)&CHAR(RAND()*10+48)&CHAR(RAND()*10+48)&CHAR(RAND()*26+97)&CHAR(RAND()*26+97)&CHAR(RAND()*26+97)
to be copied down.
When you have enough, you can copy column A and do a 'paste special / values' to fix the passwords.
I don't check for duplicates, the probability being extremely low...
eric
in A1:
=CHAR(RAND()*26+65)&CHAR(RAND()*26+65)&CHAR(RAND()*26+65)&CHAR(RAND()*10+48)&CHAR(RAND()*10+48)&CHAR(RAND()*26+97)&CHAR(RAND()*26+97)&CHAR(RAND()*26+97)
to be copied down.
When you have enough, you can copy column A and do a 'paste special / values' to fix the passwords.
I don't check for duplicates, the probability being extremely low...
eric
