Excel中如何使用随机函数生成8位数字或者数字与字母混合的密码，首尾可以为数字0

Question

如题所述

Answer 1

数字密码
=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重算。

Answer 2

纯8位数字:
=TEXT(INT(RAND()*100000000),"00000000")