数字密码
=TEXT(INT(RAND()*100000000),"00000000")
混合密码
b1至b36依次填充0-9,A-Z
a1=INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)&INDEX(B:B,RAND()*37)
如不满意,按F9重算。
纯8位数字:
=TEXT(INT(RAND()*100000000),"00000000")