Excel 隨機英數

反正要用就寫出來

=if(RANDBETWEEN(0,1),XX,YY)
1執行XX,0執行YY
XX—>INT(RAND()*(10-0))
YY—>CHAR(INT(RAND()*24)+if(INT(RAND()*2)=0,65,97))

if(RANDBETWEEN(0,1),INT(RAND()*(10-0)),CHAR(INT(RAND()*24)+if(INT(RAND()*2)=0,65,97))) <-1個隨機英數混合

PP <— if(RANDBETWEEN(0,1),INT(RAND()*(10-0)),CHAR(INT(RAND()*24)+if(INT(RAND()*2)=0,65,97)))

N 位英數混就在後面加 PP & PP & PP & ….