Excel randomly generates data

The CONCATENATE function is a text join function, very simple, and the same as the & effect.

Concatenate is a text join function

Syntax: Concatenate (TEXT1,TEXT2,TEXT3 ...)

Where text represents one of the texts to be concatenated together.

Random lowercase letters: =char (INT (RAND () *25+97))

Random Capital letters: =char (INT (RAND () *25+65))

Random number: =char (INT (RAND () *9+48))

Random number uppercase and lowercase letters: if (int (rand () *) =0,char (int (rand () *9+48)), if (Int (rand () *) =0,char (int (rand () *25+65)), CHAR (int (rand) *25+97))))

Mixed 6-bit: =concatenate (if (int () * *) =0,char (int (rand () *9+48)), if (Int (rand () *) =0,char (int (rand () *25+65)), CHAR ( Int (rand () *25+97))), if (Int (rand () *) =0,char (int (rand () *9+48)), if (Int (rand () *) =0,char (int (rand () *25+65)), CHAR (Int (rand () *25+97))), if (Int (rand () *) =0,char (int (rand () *9+48)), if (Int (rand () *) =0,char (int (rand () *25+65)), CHAR (int (rand () *25+97))), if (Int (rand () *) =0,char (int (rand () *9+48)), if (Int (rand () *) =0,char (int (rand () *25+65)) , CHAR (int (rand () *25+97))), if (Int (rand ()) =0,char (int (rand () *9+48)), if (Int (rand ()) =0,char (int (rand () *25+65) ), CHAR (int (rand () *25+97))), if (Int (rand () *) =0,char (int (rand () *9+48)), if (Int (rand () * *) =0,char (int (rand ()) *25+65 )), CHAR (INT (RAND () *25+97)))))

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

The probability of the number is equal to 50%, the correct proportion should be 11/62, the proposed change

CHAR (INT (IF (rand () <10/62,rand () *10+48,rand () *26+65+ (rand () <0.5) *32))

Excel randomly generates data