wps的excel怎么生成只有大写字母和数字组成的8位编码

2025-03-07 08:57:37

推荐回答（2个）

回答1：

=IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))

说明：IF(RAND()>0.5,CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))重复8次，用&连接。
如果RANDBETWEEN函数不可用，并返回错误值 #NAME?，请安装并加载“分析工具库”加载宏。

回答2：

=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),CHAR(INT(RAND()*25+65))))

每组去掉一个判断“IF(INT(RAND()*2)=0”，再删去“CHAR(INT(RAND()*25+97))”部分