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

◄ You can't really compare what we do to other departments in the Bureau

2018-01-22Generate strong passwords quickly with Excel

0 comments

Tags All Tech Personal

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.


ADD COMMENT

Tags All Tech Personal