第1个回答 2014-12-09
=CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))&CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))
实际就是下面这个公式重复8次
=CHOOSE(RANDBETWEEN(1,3),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(97,112)),RANDBETWEEN(0,9))
第2个回答 2014-12-09
不太明白楼主的意思,是一个大写字母外加8位随机数就是
=CHOOSE(RANDBETWEEN(1,26),"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")&RANDBETWEEN(10000000,99999999)
追问我要1000个随机生成的数字,8位数,里面可以是字母和数字的混合,不限定字母在第几位