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

Question

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

我先输入的是这个，是大小写字母和数字混合的，我想去掉小写字母

Answer 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?，请安装并加载“分析工具库”加载宏。

Answer 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))”部分本回答被提问者采纳