作者:乔山办公网日期:
返回目录:excel表格制作
=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}))
方法:以8位随机码为知例。
1、打开EXCEL表格,在任意单元格输入:=TEXT(INT(RAND()*100000000),"00000000")
2、向下或道向右拖动填充手柄,就可以改变数值。
注:内如更需要更改数值,可将中间的“容100000000”的0增加/减少。
Ctrl+F 查找后 Ctrl+A
然后 设置 格式
到这一步 按 Ctrl +A
比如这个:
=RANDBETWEEN(10000000,99999999)
采用以上函数自动生成8位随机数字密码
你查询一下这个函数,可以限定生成的字符包括:数字、大小写字母等。