EXCEL单元格如何随机生成字母

=LOOKUP(RANDBETWEEN(1,5),{1,2,3,4,5},{"A","B","C","D","E"})

如果有需要，可已将5改成26，这样，对应的就是返回任意26个字母了。

=LOOKUP(RANDBETWEEN(1,26),{1,2,3,4,5，……25，26},{"A","B","C","D","E"，……"Z"})

=CHAR(65+INT(RAND()*6))
或者：=CHAR(65+INT(RANDBETWEEN(0,6)))

CHAR是根据字母的ASC码值，转换成相应的字母。
字母A的ASC码值是65，B是66，其他以此类推！
Rand随机函数*6，就表示0-5个字符，也就是65,66,67,68,69,70，分别对应A,B,C,D,E,F
Int是取整函数！

要生成其他字母，以此类推即可！

第2个很简单：
="校验码
"&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&"
"&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&"
"&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&"
"&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)&int(rand()*10)
第一个麻烦一些，用宏自定义函数，你接受吗？

=CHAR(RANDBETWEEN(65,70))
A~F

A-F

=CHAR(65+RAND()*4)
J-N
=CHAR(74+RAND()*4)