How to generate random and bulk password in Excel?

You may create a random password in Excel by using a mixture of the functions in Excel to ensure that the password is secure and unique. I will provide you with step-by-step guidance on how to do this below. This will include instructions for building passwords that match common security standards, such as incorporating uppercase and lowercase letters, digits, and special characters.
To create a random password in Excel that is eight characters long and includes letters, numbers, and special characters, use the formula below:

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(48,57))&CHAR(RANDBETWEEN(33,47))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(48,57))&CHAR(RANDBETWEEN(58,64))

After that, press the Enter key on the keyboard to generate a random password that is 8 characters long and has 2 uppercase letters, 2 lowercase letters, 2 digits, and 2 special characters. Remember, whenever the Excel sheet refreshes, the passwords will change. Therefore, after generating these passwords, copying and pasting them as plain text is preferable.

This is an explanation of the formula. Once you understand this, you can make the formula longer or shorter to adjust the position of the characters.