在一张EXCEL表格中如何快速提取出移动的手机号？
发布网友
共1个回答
热心网友
=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)="1","电信",IF(LEFT(K2,3)="181","电信",IF(LEFT(K2,3)="199","电信",IF(LEFT(K2,3)="173","联通",IF(LEFT(K2,3)="177","电信","")))))))))))))))))))))))))))))))))))))))
