怎样用Excel表格生成乱码数据？

Question

我想用Excel表格生成乱码数据，要求是4位数的数据，用来做刮奖卡的密码的。

Answer 1

0-9和A-Z 数字加字母混合在一起的随机码，字母不区分大小写！可以做

Answer 2

只用数字还是数字和字符？字符的范围是什么？

字母大小写随机出现。数组公式，按Ctrl+Shift+Enter组合键完成最后输入
=CHAR(SMALL(((ROW(A1:A122)>47)*(ROW(A1:A122)<58)+(ROW(A1:A122)>64)*(ROW(A1:A122)<91)+(ROW(A1:A122)>96)*(ROW(A1:A122)<123))*ROW(A1:A122),RANDBETWEEN(61,122)))&CHAR(SMALL(((ROW(A1:A122)>47)*(ROW(A1:A122)<58)+(ROW(A1:A122)>64)*(ROW(A1:A122)<91)+(ROW(A1:A122)>96)*(ROW(A1:A122)<123))*ROW(A1:A122),RANDBETWEEN(61,122)))&CHAR(SMALL(((ROW(A1:A122)>47)*(ROW(A1:A122)<58)+(ROW(A1:A122)>64)*(ROW(A1:A122)<91)+(ROW(A1:A122)>96)*(ROW(A1:A122)<123))*ROW(A1:A122),RANDBETWEEN(61,122)))&CHAR(SMALL(((ROW(A1:A122)>47)*(ROW(A1:A122)<58)+(ROW(A1:A122)>64)*(ROW(A1:A122)<91)+(ROW(A1:A122)>96)*(ROW(A1:A122)<123))*ROW(A1:A122),RANDBETWEEN(61,122)))本回答被提问者采纳

Answer 3

你还不如 去下一个随机密码生成器