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中怎样生成随机的4位字母数字组合,谢谢答:获取一位随机字母或数字就是 =IF(RANDBETWEEN(0,1)=0,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(48,57)))获取4位你把这个公式复制4次中间用&连接就行了,比如2位就是 IF(RANDBETWEEN(0,1)=0,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(48,57)))&IF(RANDBETWEEN(0,1)=0,CHAR(RANDBETWEEN...