EXCEL随机生成20位数字，中间加上空格的代码，如： 2345 4566 7755 5566 6765

显示全部楼层 · 2012-4-4 13:33:51

在A1，中输入：=RANDBETWEEN(1000,9999)在B1，中输入：=RANDBETWEEN(1000,9999)在C1，中输入：=RANDBETWEEN(1000,9999)在D1，中输入：=RANDBETWEEN(1000,9999)在E1中输入：=A1&" "&B1&" "&C1&" "&D1就可以随机生成： 2345 4566 7755 5566 6765...

千问 · 2012-4-4 13:33:51

=TEXT(MID(RAND(),3,12),"0000 0000 0000 ")&TEXT(MID(RAND(),3,8),"0000 0000")...

千问 · 2012-4-4 13:33:51

=TEXT(INT(RAND()*10000000000),"0000 0000 00")&TEXT(INT(RAND()*10000000000),"00 0000 0000")...

千问 · 2012-4-4 13:33:51

=ROUND(RAND()*10000,0)&" "&ROUND(RAND()*10000,0)&" "&ROUND(RAND()*10000,0)&" "&ROUND(RAND()*10000,0)&" "&ROUND(RAND()*10000,0)...

千问 · 2012-4-4 13:33:51

1楼2楼都是正确的...