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-22Generate strong passwords quickly with Excel

0 comments

Tags All Tech

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