0%

excel随机生成密码

excel随机生成密码
QQ群:397745473

大小写字母和数字混合的密码

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

随机1位小写字母:

1
=CHAR(INT(RAND()*26)+97)

随机1位大写字母:

1
=CHAR(INT(RAND()*26)+65)

随机1位大小写混合字母:

1
=CHAR(INT(RAND()*26)+if(INT(RAND()*2)=0,65,97))

产生随机的10位数的大小写混合字母和数字混合:

1
=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))))
1
=CONCATENATE(IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))),IF(ROUND(RAND(),0),CHAR(RANDBETWEEN(48,57)),CHAR(RANDBETWEEN(65,90))))

QQ群:397745473

欢迎关注我的其它发布渠道