How to Make a Password with Random Letters and Numbers in Excel - Tutorial

Excel tutorial to learn how to create a password using random letters and numbers in Excel. We’ll create a password generator file that you can save and use anytime you need a new password.

In this example, we’ll make a password that will have 7 random characters made up of uppercase case letters, lowercase letters, numbers, and symbols.

We'll create our password generator file by using a combination of the CHAR function, the RANDBETWEEN function, and the LOWER function.

What is the CHAR formula in Excel?
The CHAR formula translates computer code (ASCII) into familiar letters, numbers and symbols.

What is the RANDBETWEEN formula in Excel?
The RANDBETWEEN formula generates a random number based on a set range. Between 1 and 10, for example.

What is the LOWER formula in Excel?
The LOWER formula is used to change capitalization. Using LOWER changes all text to lowercase.

For more on these formulas, take a look at these other free Excel tutorials -

How to Generate Random Numbers in Excel Using RAND function & RANDBETWEEN Excel function - Tutorial: youtu.be/FrU-pqFLcQE

and

How to Change Case in Excel: How to Use PROPER, UPPER & LOWER Functions - Tutorial: youtu.be/Di5bwVWavnQ

For another fun use of the CHAR function, take a look at our Excel tutorial on How to Make a Word Search puzzle in Excel: youtu.be/xcoWS8EGywI

And, If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/

*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365

The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials