Generating Random Characters in Excel to Produce Passwords

preview_player
Показать описание
This video demonstrates how to generate random characters and numbers using Excel. Random combinations of uppercase letters, lowercase letters, special characters, and numbers may be used to produce passwords.
Рекомендации по теме
Комментарии
Автор

Thanks for sharing! This shows me a way to generate passwords using the formulas, which is really neat!

TechTinkTronics
Автор

Thank you very much for sharing this information, especially the last bit with CHAR(TRUNC(RAND()*90+33)), this saved me allot of time.
The only problem i have is that everytime i open the worksheet the passwords change, which is a problem. Is there maybe a way to lock the cells so it does not create a new password everytime i open the file...

michaelswart