在B1中输入或复制粘贴此公式
=IF(OR(--LEFT(A1,3)={134,135,136,137,138,139,147,150,151,152,157,158,159,182,187,188}),"移动","")
或
=IF(OR(--MID(A1,2,2)={34,35,36,37,38,39,47,50,51,52,57,58,59,82,87,88}),"移动","")
=IF(OR(--LEFT(A1,3)={134,135,136,137,138,139,147,150,151,152,157,158,159,182,187,188}),A1,"")
或
=IF(OR(--MID(A1,2,2)={34,35,36,37,38,39,47,50,51,52,57,58,59,82,87,88}),A1,"")
下拉填充
将B列排序
删除结果为空的各行
