=CHAR(IF(RANDBETWEEN(1,3)=1,RANDBETWEEN(65,72),(IF(RANDBETWEEN(2,3)=2,RANDBETWEEN(74,78),RANDBETWEEN(80,90)))))&
CHAR(IF(RANDBETWEEN(1,3)=1,RANDBETWEEN(97,107),(IF(RANDBETWEEN(2,3)=2,RANDBETWEEN(109,110),RANDBETWEEN(112,122)))))&
CHAR(IF(RANDBETWEEN(1,3)=1,RANDBETWEEN(97,107),(IF(RANDBETWEEN(2,3)=2,RANDBETWEEN(109,110),RANDBETWEEN(112,122)))))&
CHAR(RANDBETWEEN(50,57))&
CHAR(RANDBETWEEN(50,57))&
CHAR(RANDBETWEEN(50,57))&
CHAR(RANDBETWEEN(50,57))&
CHAR(RANDBETWEEN(50,57))&
CHAR(RANDBETWEEN(50,57))&
CHAR(RANDBETWEEN(50,57))
第一个&前是大写字母,且不含有歧义的字符
第二个&前是小写字母,且不含有歧义的字符
第三个&前是小写字母,且不含有歧义的字符
第四个&前是数字,且不含有歧义的字符
Excel 用函数给出随机的复杂密码 且不含有歧义的字符
原创
©著作权归作者所有:来自51CTO博客作者wangheyu1的原创作品,请联系作者获取转载授权,否则将追究法律责任
![](https://ucenter.51cto.com/images/noavatar_middle.gif)
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
java密码复杂度实现
java密码复杂度实现
复杂度 Java 正则表达式