Question

在EXCEL中，能不能用函数随机生成六位数字字母组合

★在EXCEL中，能不能用函数随机生成六位......★=IF(RANDBETWEEN(1,3)......在EXCEL中，能不能用函数随机生成六位数字字母组合，字母区分大小写。谢谢各位大侠了,急用呀!!!

Answer 1

=INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))&INDEX({1,2,3,4,5,6,7,8,9,0,"a","b","c","d","e","f","g","","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z"},ROUND(RAND()*35+1,0))
虽然有点长，但你可以看出是六位随机数并成的，如仍觉长，可以将10位数字，26*2个字母定义为一个区域，我这儿是一步到位

Answer 2

=MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ",INT(RAND()*36)+1,1)

Answer 3

=MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwsyz",INT(RAND()*62)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwsyz",INT(RAND()*62)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwsyz",INT(RAND()*62)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwsyz",INT(RAND()*62)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwsyz",INT(RAND()*62)+1,1)&MID("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwsyz",INT(RAND()*62)+1,1)