EXCEL 中随机产生16位数字的代码！

最新推荐文章于 2025-03-28 09:47:27 发布

weilaibuxiangshuo

最新推荐文章于 2025-03-28 09:47:27 发布

阅读量3.9k

点赞数

=CONCATENATE(CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))),CHAR(INT(CHOOSE(INT(RAND()*2.999+1),RAND()*9+48,RAND()*25+65,RAND()*25+97))))

随机产生大小写字母跟数字组合的代码：

=CHAR(INDEX({97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122},INT(RAND()*23)+1))&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90},INT(RAND()*23)+1))&CHAR(INDEX({97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122},INT(RAND()*23)+1))&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90},INT(RAND()*23)+1))&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&CHAR(INDEX({97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122},INT(RAND()*23)+1))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90},INT(RAND()*23)+1))&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90},INT(RAND()*23)+1))&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&CHAR(INDEX({97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122},INT(RAND()*23)+1))&CHAR(INDEX({65,66,67,68,69,70,72,74,75,76,77,78,80,81,82,83,84,85,86,87,88,89,90},INT(RAND()*23)+1))&INDEX({2,3,4,5,7,8,9},INT(RAND()*7)+1)&CHAR(INDEX({97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122},INT(RAND()*23)+1))