跳转到主要内容

excel生成随机12位密码

分类
故障描述
  无
故障分析

  无

处理过程

在Excel下用下面公式自动生成12位加密密码

=TEXTJOIN("", TRUE, CHAR(RANDBETWEEN(65,90)), CHAR(RANDBETWEEN(97,122)), CHAR(RANDBETWEEN(48,57)), CHAR(CHOOSE(RANDBETWEEN(1,4),64,35,36,38)), CHAR(RANDBETWEEN(65,90)), CHAR(RANDBETWEEN(97,122)), CHAR(RANDBETWEEN(48,57)), CHAR(CHOOSE(RANDBETWEEN(1,4),64,35,36,38)), CHAR(RANDBETWEEN(65,90)), CHAR(RANDBETWEEN(97,122)), CHAR(RANDBETWEEN(48,57)), CHAR(CHOOSE(RANDBETWEEN(1,4),64,35,36,38)))

建议/总结

  无