在EXCEL中,能不能用函数随机生成六位数字字母组合

来源:百度知道 编辑:UC知道 时间:2024/07/03 04:29:24
在EXCEL中,能不能用函数随机生成六位数字字母组合,字母区分大小写。谢谢各位大侠了,急用呀!!!

=IF(RANDBETWEEN(1,3)=1,CHAR(RANDBETWEEN(48,57)),IF(RANDBETWEEN(1,3)=2,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122))))&IF(RANDBETWEEN(1,3)=1,CHAR(RANDBETWEEN(48,57)),IF(RANDBETWEEN(1,3)=2,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122))))&IF(RANDBETWEEN(1,3)=1,CHAR(RANDBETWEEN(48,57)),IF(RANDBETWEEN(1,3)=2,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122))))&IF(RANDBETWEEN(1,3)=1,CHAR(RANDBETWEEN(48,57)),IF(RANDBETWEEN(1,3)=2,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122))))&IF(RANDBETWEEN(1,3)=1,CHAR(RANDBETWEEN(48,57)),IF(RANDBETWEEN(1,3)=2,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122))))&IF(RANDBETWEEN(1,3)=1,CHAR(RANDBETWEEN(48,57)),IF(RANDBETWEEN(1,3)=2,CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122))))

难度大在,ASC码分布是这样的。48到57是数字0-9,65-90是大写字母,97到122是小写字母,不连续,计算会比较麻烦。
找到一种简单办法。
你把0-9,a-z,A-Z,输入到A1至A62--这并不难吧。
然后,在B1输入=INT(RAND()*62),然后右拉到G1.也好做
最后,在1中输入=INDIRECT("A"&B1)&INDIRECT("A"&C1)&INDIRECT("A"&D1)&INDIRE