wps的excel怎么生成只有大写字母和数字组成的8位编码答: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?,请安装并加载“分析工具库”加载宏。