请教EXCEL里随机码生成代码,共十位,包含字母大小写、数字(0、1除外),请各位大虾指教,谢谢!!!!

如题所述

=CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,122)),RANDBETWEEN(2,9))
温馨提示:答案为网友推荐,仅供参考
第1个回答  2016-10-09
这个需要用自定义函数来实现
相似回答