Generating Random Passwords in Excel

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


Links which I found useful in generating the formula;