How does one generate a password containing lowercase letters, uppercase letters, and numbers? To generate a 13 character password, such as one needed for use with a wireless network router's 128 bit encryption wired equivalent protocol (WEP), do the following:
In A1:A13 enter the formula =INT(RAND()*62). This generates random values from a selection of 62 numbers between 0 and 61 (10 digits + 2*26 letters since we are differentiating between lowercase and uppercase characters).
In B1 enter the formula =IF(A1<10,A1,IF(A1<36,CHAR(A1-10+65),CHAR(A1-36+97))). Copy B1 to B2:B13. Column B gives you a list of 13 random letters or numbers.
To get only uppercase letters or digits, use =INT(RAND()*36) and =IF(A16<10,A16,CHAR(A16-10+65))
To get only lowercase letters of digits, use =INT(RAND()*36) and =IF(A22<10,A22,CHAR(A22-10+97))