=LOWER(CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(48,57))&CHAR(RANDBETWEEN(48,57))&CHAR(RANDBETWEEN(48,57)))
48,57 就是数字；
65,90 就是字母；
lower() 是小写字母函数
=LOWER(CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(48,57))&CHAR(RANDBETWEEN(48,57))&CHAR(RANDBETWEEN(48,57)))
48,57 就是数字；
65,90 就是字母；
lower() 是小写字母函数
本文标题：excel 生成6为随机字母+数字
本文链接：https://www.haomeiwen.com/subject/bmxnmttx.html
网友评论