Please refer to the tables below for more details. Although you can give it numbers between 1 and 255 to get a character, not every character is suitable for passwords such as space or new line characters. The CHAR function returns a string character from an ANSI character code. You can generate random characters by combining the CHAR and RANDBETWEEN functions. Type in or select each cell for the CONCATENATE function to combine everything and create password =CONCATENATE(G3,G4,G5,G6,G7,G8,G9,G10).Copy down the formula for the rest of the rows (i.e.Make sure the first argument is absolute and covers the original list. Type in =INDEX($D$3:$D$10,F3) to get the values from the original list in random order.Select a new cell that is to be the first cell of the shuffled list (i.e.Make sure the first argument is relative and the second is absolute that. Type in =RANK(E3,$E$3:$E$10) to return a list of ranks.Select the cell from the column that is right next to it (i.e.Make sure the second argument of RANDBETWEEN is greater than or equal to the number of list items and the last number that divides the ROW function has more digits than the number of list items. Type in =RANDBETWEEN(1,8)+ROW()/10000 to generate random unique numbers.Select the cell from the column that is right next to list (i.e.Copy all formulas to new cells to generate different characters for a 8-character length password (i.e.Type in =CHAR(RANDBETWEEN(33,47)) to generate a special character.Type in =CHAR(RANDBETWEEN(97,122)) to generate a lowercase letter.Type in =CHAR(RANDBETWEEN(65,90)) to generate an uppercase letter.Type in =RANDBETWEEN(0,9) to generate a random number.=CONCATENATE(all random generated characters,…) Steps =INDEX( original list, rank of generated random number) Combining Characters =RANK( generated random number, list of generated random numbers)

=RANDBETWEEN( 1, count of list items ) + ROW() / very large number that has more digits than the number of list items) =CHAR(RANDBETWEEN(33,47)) (Symbol) Character Order =CHAR(RANDBETWEEN(97,122)) (Lowercase Letter) =CHAR(RANDBETWEEN(65,90)) (Uppercase Letter)

Download 20 char password generator