Excel 產生亂數數字、字母

=CHAR(MOD(INT(RAND()*10000),26)+65)&CHAR(MOD(INT(RAND()*10000),26)+65)& INT(RAND()*10000)

 
Reference :
Random Alphanumeric Values in Excel | Click Consulting