如何在<em>EXCEL</em>中生成八位数的大写字母加数字的随机字符串？-excel 随机生

比如这个：
=RANDBETWEEN(10000000,99999999)
采用以上函数自动生成8位随机数字密码
你查询一下这个函数，可以限定生成的字符包括：数字、大小写字母等。

=CONCATENATE(LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}),LOOKUP(RANDBETWEEN(1,31),{1,"A";2,"B";3,"C";4,"D";5,"E";6,"F";7,"G";8,"H";9,"I";10,"J";11,"K";12,"L";13,"M";14,"N";15,"P";16,"Q";17,"R";18,"S";19,"T";20,"U";21,"V";22,"W";23,"X";24,"Y";25,3;26,4;27,5;28,6;29,7;30,8;31,9}))

1、以百B列为辅助列，选择B1:B100单元格，输入以下公式度，按Ctrl+Enter组合键结束

=RAND()

2、输问入以下公式，得到A列的答随机专且不重复的5个单元格字符属组成的字符串

=INDEX(A:A,MATCH(LARGE(B:B,1),B:B,0))&INDEX(A:A,MATCH(LARGE(B:B,2),B:B,0))&INDEX(A:A,MATCH(LARGE(B:B,3),B:B,0))&INDEX(A:A,MATCH(LARGE(B:B,4),B:B,0))&INDEX(A:A,MATCH(LARGE(B:B,5),B:B,0))

按F9可自动更新随机字符串的结果

随机函数RAND，语法=RAND()*(上限－下限)+下限。
随机函数产生的只是一组随机数字。
如果要产生随机非数字的字符串，可另建辅助表作为源数据，再借用查找函数VLOOKUP或索引函e799bee5baa6e79fa5e98193e78988e69d83330数INDEX返回数字对应的非数字字符串。

回答者： Stcxj - 十五级 2010-11-1 21:19

重新补充啦：
A B
0 0
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 +
11 -
12 *
13 /
14 >
15 <
输入
=CONCATENATE(VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,),VLOOKUP(INT(RAND()*16),A:B,2,))