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

Pin It on Pinterest

Share This

Spread the Good News!

Do me favour, please? Share this with your friends!

Thanks For Commenting!

Awesome for you to comment! Please share the post with your friends.