Question

怎么在EXCEL生成8位随机数字

要求：8位随机数字和大写英文字母的混合。

Answer 1

使用函数指令可以完成。

单元格=ROUNDDOWN((RAND()*99999999),0)

按F9刷新即变化随机8位数

ROUNDDOWN(number,num_digits)

Number 为向下舍入的任意实数。这个参数用的不多。

Num_digits 四舍五入后的数字的位数。这个参数用的不多。

rand()函数产生随机数的一个随机函数。

99999999这八位数的9代表单元格的随机数是8位且不大于99999999

最后一位0表示没有小数点，随机数为整数。

Answer 2

=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))

Answer 3

不太明白楼主的意思，是一个大写字母外加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位数，里面可以是字母和数字的混合，不限定字母在第几位

Answer 4

如附件

 

追问

看不懂，大神，里面怎么操作

追答

按F9 刷新， 随机生成 字母+数字的啊

要1000个 就把B列 公式 直接下拉填充到 B1000就可以了

追问

T T怎么操作，基本没用过excel

追答

那我 弄1000个重新放上来 给你就完了，

你只需要 按F9 刷新就 会重新生成随机的1000个

 

 

Answer 5

=randbetween(10000000,99999999)