Excel根据手机号区分运营商

发布于:2021-09-13 12:00:31

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,131,132,145,146,155,156,166,171,175,176,185,186},--LEFT(C2,4)={1704,1707,1708,1709}),"联通","电信"))

相关推荐