One many occasions I have had to generate a bulk number of passwords for new users and service accounts across the system. Excel is amazing and through the use of some simple formula, you can generate random passwords into a cell or column.
Formula I use;
Tip: In the formula, CHAR(RANDBETWEEN(65,90)) can get one alpha character, RANDBETWEEN(10,99) can get a two-digit number, you can change the formula combination to your need. For instance, 8 digit alphanumeric password, use this formula
=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9999)&CHAR(RANDBETWEEN(65,90)&CHAR(RANDBETWEEN(65,90))
Links which I found useful in generating the formula;
https://www.extendoffice.com/documents/excel/5004-excel-generate-random-password.html
Comments: