Generating Strong Passwords or Encryption keys Using Excel
A strong password should be at least 16 characters long, include special characters, Numbers, uppercase letters and lowercase letters. A mix of all these characters makes it hard for the password to crack.
Most people find it hard to create a strong password but with Excel RANDBETWEEN and CHAR functions I will show you how to generate a strong and unique password.
In below example we are going to generate 16 characters passwords made up of;
- 4 special characters,
- 6 small letters,
- 3 capital letters
- 3 numbers
►Just fill in the number of passwords required and click “Generate Passwords” button
How it Works:
►CHAR function generates characters based on their numeric code.(See Character Encoding)
For example: CHAR(64)=?
►RANDBETWEEN functions generates a random number in a given range.
For example: RANDBETWEEN (58,64)= 61 or 59 or 64…
Therefore, CHAR(RANDBETWEEN (58,64)) will generate any of below special characters everytime the function recalculates
: ; < = > ? @
►The arrangement of the characters in the password is dependent on the range of numeric code passed to RANDBETWEEN
For example for a password to start with a small letter then a special character use
►You can use the worksheet to generate Encryption keys or Unique Primary Keys to be used in a database
Download RANDOM PASSWORDS GENERATOR