Excel中如何设置随机密码

暗香疏影创作者

2021-03-22 2021-03-22 创建 2021-03-22 2021-03-22 更新

Excel中设置随机数字

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)

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