Excel中如何设置随机密码

繁华是客

发布于 2023-03-03 20:10:27

1.8K0

Step 1:

将以下代码复制进去

=TRUNC(RAND()*(High-Low)+Low)
##
=TRUNC(RAND()*(3000-1000)+1000)
## 或者：
=RANDBETWEEN(1000,3000)

#大写字母
=CHAR(RANDBETWEEN(65,90))

#小写字母
=CHAR(RANDBETWEEN(97,122))

#特殊字符
=CHAR(RANDBETWEEN(33,47))

#合并成密码

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(1000,3000)

最后通过复制该列并粘贴成值即可。

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2021-03-22 ，如有侵权请联系 cloudcommunity@tencent.com 删除