水一篇,关于如何使用excel生成随机手机号。
A1 = CHOOSE(RANDBETWEEN(1,5),131,135,137,139,151)
B1 = RANDBETWEEN(10000000,99999999)
C1 = A1&B1
水一篇,关于如何使用excel生成随机手机号。
A1 = CHOOSE(RANDBETWEEN(1,5),131,135,137,139,151)
B1 = RANDBETWEEN(10000000,99999999)
C1 = A1&B1