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)
最后通过复制该列并粘贴成值即可。