Excel中设置随机数字

Lifewire

Step 1:

将以下代码复制进去

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

Excel中设置随机字母

ExcelZoom

#大写字母
=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)

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