Project Zebra: WE KNOW THAT YOU CAN HEAR US EARTHMEN ►

◄ Project Zebra: You can't really compare what we do to other departments

2018-01-22 📌 Generate strong passwords quickly with Excel

Tags 🏷 All 🏷 Tech 🏷 Audit

This isn't particularly original, and was inspired by seeing a few solutions. Looking back, probably:

https://stackoverflow.com/questions/17905015/excel-vba-convert-string-to-phonetic-alphabet
https://www.extendoffice.com/documents/excel/642-excel-generate-random-string.html

Add the VBA below in a new module, then the following formulas:

A1 =Scramble(CHAR(RANDBETWEEN(65,90)) &CHAR(RANDBETWEEN(65,90)) &CHAR(RANDBETWEEN(65,90)) &CHAR(RANDBETWEEN(36,38)) &RANDBETWEEN(10,99) &LOWER(CHAR(RANDBETWEEN(65,90)) &CHAR(RANDBETWEEN(65,90)) &RANDBETWEEN(10,99)))

B1 =Wordify(A1)

Which'll give you a fairly strong ten character password for initial allocation plus description of it suitable for giving to the user to help them type it. It's handy for bulk generation too.

💬 Comments are off, but you can use the mail form to contact or see the about page for social media links.