Excel根据手机号区分运营商
Excel公式中填写此公式,下拉覆盖后面的空格就可以了=IF(OR(--LEFT(C2,3)={134,135,136,137,138,139,147,148,150,151,152,157,158,159,172,178,182,183,184,187,188,198},--LEFT(C2,4)={1705,1703,1706}),"移动",IF(OR(--LEFT(C2,3)={130,1...
原创
2019-11-26 14:47:41 ·
5544 阅读 ·
0 评论