excel随机生成4位字母加数字的随机数,字母要求为A-F答:把公式输入到任何一个单元格,向下或者横向填充即可,每双击一次都会更换一组 =INDEX({0,"a",4,"e";1,"b",5,"f";2,"c",6,8;3,"d",7,9},RANDBETWEEN(1,4),RANDBETWEEN(1,4))&INDEX({0,"a",4,"e";1,"b",5,"f";2,"c",6,8;3,"d"...
EXCEL单元格如何随机生成字母答:=LOOKUP(RANDBETWEEN(1,5),{1,2,3,4,5},{"A","B","C","D","E"})如果有需要,可已将5改成26,这样,对应的就是返回任意26个字母了。=LOOKUP(RANDBETWEEN(1,26),{1,2,3,4,5,……25,26},{"A","B","C","D","E",……"Z"})...