excel中区分移动联通电信号码

excel函数如下：(2021年6月2日，更新最新号段)

可直接复制以下公式：

=IF(OR(--LEFT(A1,3)={134,135,136,137,138,139,140,141,143,147,148,150,151,152,154,157,158,159,165,172,178,182,183,184,187,188,195,197,198},--LEFT(A1,4)={1705,1703,1706}),"移动",IF(OR( --LEFT(A1,3)={175,176,156,130,131,132,155,186,145,185,171,146,166,167,191,196}, --LEFT(A1,4)={1704,1707,1708,1709}),"联通","电信"))

------------------------------------------------------------------------------------------

以下有换行符，如果贴到excel中，需要将空格或者换行符删除，联通电信才会正常显示

=IF(

OR(
--LEFT(A1,3)={134,135,136,137,138,139,140,141,143,147,148,150,151,152,154,157,158,159,165,172,178,182,183,184,187,188,195,197,198},
--LEFT(A1,4)={1705,1703,1706}),
"移动",
IF(OR(
  --LEFT(A1,3)={175,176,156,130,131,132,155,186,145,185,171,146,166,167,191,196},
  --LEFT(A1,4)={1704,1707,1708,1709}),
"联通",
"电信")

)

如下图所示：将excel公式复制单元格中，移动拖柄或双击就可以将三网的号码区分出来。

电信最新号段：133,1349,149,153,162,173,174,177,180,181,189,190,193,199,1700,1701,1702