# Generate Random Passwords

This post will teach you how to quickly **generate a random password** with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel.

## Generate Random Password

Normally, a secure password should have 8 characters at least and contain a mix of uppercase letters, lowercase letters, numbers and one specific character. To generate a Random and secure password in Excel, you can use a combination of the CHAR function, the RANDBETWEEN function and concatenation operator to build a new Excel formula. Just refer to the following formula.

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(100,999)&CHAR(RANDBETWEEN(42,43))

Select one cell that you want to generate the random password, then enter this formula in that Cell, and press **Enter** key to apply this formula. You will see that it will generate an eight characters password.

If you want to generate a random password only contain alpha characters (random uppercase letter string), you can use the following formula:

=CHAR(RANDBETWEEN(65,90))

** **

If you want only to generate a random lowercase letter string, you can use the below formula:

=CHAR(RANDBETWEEN(97,122))

If you want to generate a random password only contain 6-digit numeric characters, you can use the following formula:

=RANDBETWEEN(100000,900000)

If you want to generate a random symbol string, just use the following formula:

=CHAR(RANDBETWEEN(33,47))

This formula will randomly generate one of the following specific characters: !”#$%&'()*+,-./

We talked that the CHAR function will generate lots of specific characters, and if you just want to create a password that can be type on the keyboard, so you should keep the specific character simple and avoid to use characters like ¶, Œ, or ©.

### Related Functions

- Excel CHAR function

The Excel CHAR function returns the character specified by a number (ASCII Value).The CHAR function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The syntax of the CHAR function is as below:=CHAR(number)…. - Excel RANDBETWEEN Function

The Excel RANDBETWEEN function returns a random integer number that is between the numbers you specify.The syntax of the RANDBETWEEN function is as below:= RANDBETWEEN (bottom,top)….