这是公式方法完成的,字母在前数字在后,如下: =MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz",INT(RAND()*80) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1)&MID("0123456789",INT(RAND()*12) 1,1) 另外还有一种VBA实现的,如果需要的话可以追问 追答 : 这个公式在使用时,在生成字符后要把字符复制、选择性粘贴成数值格式到目标单元格内。
追答 : 生成如下图。