= RANDBETWEEN(0,9)
2.隨機小寫字母:
= CHAR(rand between(97122))
可以任意組合,例如:
1.數字+字母+字母
= rand between(0,9)& amp;CHAR(rand between(97,122))& amp;CHAR(rand between(97,122))
顛倒順序就變成了:
2.字母+數字+字母
= CHAR(rand between(97,122));rand between(0,9)& amp;CHAR(rand between(97,122))
3.字母+字母+數字
省略
描述:randbetween函數需要壹個加載項。
工具-加載項-檢查分析工具庫。