怎么在EXCEL单元格内随机生成16位数字字母答:一、随机生成16位数字加大写字母,公式:=CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,2),CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,2),CHAR(RANDB...
怎样用Excel随机函数rand()生成随机数字和大写字母,能自动产生4位混合...答:思路:先构建一个序列,1-36,右列录入为A-Z字母,0-9数字。随机字符使用randbetween()和vlookup()共同完成。字符之间使用&连接。公式为:其中$N$1:$O$26为构建的序列 =VLOOKUP(RANDBETWEEN(1,36),$N$1:$O$36,2,0)&VLOOKUP(RANDBETWEEN(1,36),$N$1:$O$36,2,0)&VLOOKUP(RANDBETWEEN(1,...