EXCEL表格里有很多行不同的联通和移动的号码，怎么提取移动的啊?
数据-分列，按步骤操作，把号码列分列，把前三位分出来，这样再用筛选就很容易筛选出130和133打头的号码了，然后删掉这些号码，剩下的就是移动的
在一张EXCEL表格中如何快速提取出移动的手机号？
1、在一列里列出所有移动号码的号段，以后如有新增可添加
2、用辅助列输入公式=COUNTIF(F:F,LEFT(A2,3))
3、对数据区域进行筛选，辅助列筛选出1
4、这样就得到所有移动号码，如果需要可复制到其他地方使用。
如何筛选EXCEL表格中移动,联通手机号码，并复制到另外一张表格中
数据——排序——升序——130至133——134——139
sheet2=sheet1中的某一格——右下角小黑十字下拉复制
我在做一个Excel表格，需要把联通移动电信的号码分别提取出来，就是说要把三个运营商都可以分出来
用LEFT函数提取手机号码头3位，根据这3位数确定此号是移动还是联通的
在E1中输入或复制粘贴下列公式
=VLOOKUP(--LEFT(D1,3),A:B,2,)
下拉填充
如何从EXCEL表格中筛选出来数据列中的手机号哪些是移动哪些是联通
=IF(LEFT(K2,3)="134","移动",IF(LEFT(K2,3)="135","移动",IF(LEFT(K2,3)="136","移动",IF(LEFT(K2,3)="137","移动",IF(LEFT(K2,3)="138","移动",IF(LEFT(K2,3)="139","移动",IF(LEFT(K2,3)="147","移动",IF(LEFT(K2,3)="150","移动",IF(LEFT(K2,3)="151","移动",IF(LEFT(K2,3)="152","移动",IF(LEFT(K2,3)="157","移动",IF(LEFT(K2,3)="158","移动",IF(LEFT(K2,3)="159","移动",IF(LEFT(K2,3)="182","移动",IF(LEFT(K2,3)="183","移动",IF(LEFT(K2,3)="187","移动",IF(LEFT(K2,3)="188","移动",IF(LEFT(K2,3)="178","移动",IF(LEFT(K2,3)="184","移动",IF(LEFT(K2,3)="198","移动",IF(LEFT(K2,3)="130","联通",IF(LEFT(K2,3)="131","联通",IF(LEFT(K2,3)="132","联通",IF(LEFT(K2,3)="155","联通",IF(LEFT(K2,3)="156","联通",IF(LEFT(K2,3)="185","联通",IF(LEFT(K2,3)="166","联通",IF(LEFT(K2,3)="175","联通",IF(LEFT(K2,3)="176","联通",IF(LEFT(K2,3)="186","联通",IF(LEFT(K2,3)="145","联通",IF(LEFT(K2,3)="133","电信",IF(LEFT(K2,3)="153","电信",IF(LEFT(K2,3)="180","电信",IF(LEFT(K2,3)="189","电信",IF(LEFT(K2,3)="181","电信",IF(LEFT(K2,3)="199","电信",IF(LEFT(K2,3)="173","联通",IF(LEFT(K2,3)="177","电信","")))))))))))))))))))))))))))))))))))))))