We use the CONCATENATE, CHAR, CODE, VLOOKUP, RAND, RANDBETWEEN, UPPER, LOWER and IF Functions to create our random password generator. We start by entering our password inputs, in other words the characters we want our password to include. We then make intermediary calculations to retrieve the random characters adjusted for their text case and finally bring these characters together to return our password using CONCATENATE.
VLOOKUP Function Excel Tutorial– Find Things In A Table:
[ Ссылка ]
IF Function Excel Tutorial:
[ Ссылка ]
Subscribe for weekly Excel tutorials, techniques and examples:
[ Ссылка ]
Please share this video with others that may find it useful:
[ Ссылка ]
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: [ Ссылка ]
📸 Instagram: [ Ссылка ]
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview: (0:00)
Inputs: (0:31)
Intermediary Calculations: (1:23)
Generate Random Password: (3:15)
