excel随机生成4位字母加数字的随机数，字母要求为A-F-excel生成随机字母和数字,excel怎么随机生成字母

=CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(0,9)&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(0,9)

把公式输入到任何zhidao一个单元格，向下或者专横向填充即可，每双击一次都会更属换一组

=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",7,9},RANDBETWEEN(1,4),RANDBETWEEN(1,4))&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",7,9},RANDBETWEEN(1,4),RANDBETWEEN(1,4))

如下图：百在B列依次列出0-9，A-Z共36个字符，在A列分别赋予序号1-36，在D1输入公式度=VLOOKUP(RANDBETWEEN(1,36),A2:B37,2,0)&VLOOKUP(RANDBETWEEN(1,36),A2:B37,2,0)&VLOOKUP(RANDBETWEEN(1,36),A2:B37,2,0)&VLOOKUP(RANDBETWEEN(1,36),A2:B37,2,0)。按F9刷新即可以内出一个随机的4位编码。

公式看起来容很长，实际也就是用&把4个VLOOKUP(RANDBETWEEN(1,36),A2:B37,2,0)连接起来。

获取一位随机百字母或数字就度是
=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(65,90)),CHAR(RANDBETWEEN(48,57)))