excel 生成6为随机字母+数字

2016-12-16 本文已影响96人 karl_song

=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 就是字母；