Excel random uppercase and lowercase letter, fixed-length letters

In Excel can produce random numbers, but also produce random letters, even random numbers and letters of the combination, want to produce a length of several.

In addition, if it is a random letter, it can also produce a single case of random letters or mixed random letters.

Here is the formula code, which I hope will help you.

① Random lowercase letters: a

=char (INT (RAND () *25+97))

② Random Capital Letter: A

=char (INT (RAND () *25+65))

③ Random Number: A

=char (INT (RAND () *9+48))

④ random digit uppercase and lowercase letters: a

if (int (rand () *2) =0,char (int (rand () *9+48)), if (Int (rand () *2) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97)))

⑤ random size letters and numbers, with a number of digits of 6 digits

=concatenate (if Int (rand () *2) =0,char (int (rand () *9+48)), if (int () () *2) =0,char (int (rand () *25+65)),

CHAR (int (rand () *25+97))), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (int () () *2) =0,char (int ()

*25+65)), CHAR (int (rand () *25+97)), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (Int (rand () *2) =0,char (

Int (rand () *25+65)), CHAR (int () *25+97)), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (int () *2)

=0,char (int (rand () *25+65)), CHAR (int (rand () *25+97)), if (Int (rand () *2) =0,char (int (rand () *9+48)), if (int () (

Rand () *2) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97)), IF (int (rand () *2) =0,char (int () () *9+48)

), IF (int (rand () *2) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97))))