excel随机生成16位字母加数字密码,字母要大写,不要全数字和全字母的,要混合的,求给公式。
=MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",RANDBETWEEN(1,36),1)