excel生成数字和大写字母的8位随机数

公式有点长，而且随机变化，

=(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))&(CHAR(IF(RAND()>0.5,RANDBETWEEN(48,57),RANDBETWEEN(65,90))))

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/fy72yvryjr3xy2j37y.html