password-866981_640

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

RANDBETWEEN Image

►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

: ; < = > ? @

NB:

►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

CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(58,64))

►You can use the worksheet to generate Encryption keys or Unique Primary Keys to be used in a database

Download RANDOM PASSWORDS GENERATOR

Related Articles:

GENERATING LOTTERY NUMBERS IN EXCEL

GENERATING RANDOM FUTURE DATES,TIME & DATETIME IN EXCEL

Leave a Comment:

Your email address will not be published. Required fields are marked *