Excel中如何设置随机密码

Excel中设置随机数字

Lifewire

Step 1:

将以下代码复制进去

代码语言：javascript复制

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

Excel中设置随机字母

ExcelZoom

代码语言：javascript复制

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

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

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

#合并成密码

代码语言：javascript复制

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

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

excel

0 人点赞