Excel文件
随机生成T13,T15,T18开头的11位电话号码
="T1"&IF(RAND()>0.3,IF(RAND()>0.6,3,5),8)&TEXT(INT(RAND()*1000000000),"000000000")
随机生成8位整数 + . + 两位小数 数字
="T"&TEXT(INT(RAND()*100000000),"00000000")&"."&TEXT(INT(RAND()*100),"00")
Excel文件
随机生成T13,T15,T18开头的11位电话号码
="T1"&IF(RAND()>0.3,IF(RAND()>0.6,3,5),8)&TEXT(INT(RAND()*1000000000),"000000000")
随机生成8位整数 + . + 两位小数 数字
="T"&TEXT(INT(RAND()*100000000),"00000000")&"."&TEXT(INT(RAND()*100),"00")