请教EXCEL里随机码生成代码，共十位，包含字母大小写、数字（0、1除外），请各位大虾指教，谢谢！！！！

 我来答

2个回答

#热议# 不吃早饭真的会得胆结石吗？

wu_zhenjiu

科技发烧友

2016-10-09 · 有一些普通的科技小锦囊

知道大有可为答主

回答量：3.1万

采纳率：79%

帮助的人：1.2亿

我也去答题访问个人页

关注

展开全部

=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))