随机生成2位字母+随机6位数字组成
=CHAR(INT(RAND()*26+97))&CHAR(INT(RAND()*26+97))&INT(RAND()*9+1)&INT(RAND()*900+100)&INT(RAND()*9+1)&INT(RAND()*9+1)
随机生成8位数字+字母
=CHAR(INT(RAND()*26+97))&INT(RAND()*9+1)&CHAR(INT(RAND()*26+97))&INT(RAND()*900+100)&CHAR(INT(RAND()*26+97))&CHAR(INT(RAND()*26+97))