输入
=CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))&CHAR(RANDBETWEEN(40,64))
公式中:通过RANDBETWEEN(40,64)返回40-64之间的随机数,然后通过CHAR将其转换为字符,然后通过10次重复并连接,生成10个随机字符,其中包括数字。
详见附图