随机生成电话号码函数公式适用于excle任意随机

随机生成电话号码函数公式适用于excle任意随机

首先 在表格处复制输入函数

=CHOOSE(RANDBETWEEN(1,6),1515204,1589525,1390522,1321235,1310245,1390522)&TEXT(RANDBETWEEN(0,10^4-1),"0000")

其中

=CHOOSE(RANDBETWEEN(1,6),1515204,1589525,1390522,1321235,1310245,1390522)&TEXT(RANDBETWEEN(0,10^4-1),"0000")

6指的是手机号段的数量 可以任意输入，比如8

=CHOOSE(RANDBETWEEN(1,8),1515204,1589525,1390522,1321235,1310245,1390522)&TEXT(RANDBETWEEN(0,10^4-1),"0000")

那么后面，这里号段也需要增加到8个例如:

=CHOOSE(RANDBETWEEN(1,8),1515204,1589525,1390522,1321235,1310245,1390522,130586,135828)&TEXT(RANDBETWEEN(0,10^4-1),"0000")

然后想要多少就下啦多少，非常实用，分享给大家！