第2个回答 2013-06-04
在EXCEL中如何使用随机函数生成8位数字或者数字与字母混合的密码,首尾可以为数字0:数字密码
=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重算。
第3个回答 2013-06-04
VBA代码如下,按alt+F11,在sheet1中双击,粘贴。工具 宏 运行宏。执行aaa即可。Sub aaa()
For i = 1 To 5000
bb = ""
aa = ""
For j = 1 To 8
a = VBA.Int(Rnd() * 3 + 1)
Select Case a
Case Is = 1
bb = Chr(64 + Int(Rnd * 26) + 1)
Case Is = 2
bb = Chr(96 + Int(Rnd * 26) + 1)
Case Is = 3
bb = Int(Rnd() * 9 + 1)
End Select
aa = aa & bb
Cells(i, 1) = aa
Next j
Next i
End Sub本回答被网友采纳