我有一批手机号码,请问如何在EXCEL把手机尾数ABAB,AABB,AAA,AAAA这样...答:假设你的手机号都在A列里面,从A1开始一直往下,你需要把靓号选出来,可以用下面的公式:=IF(RIGHT(A1,4)=REPT(RIGHT(A1),4),A1,IF(RIGHT(A1,3)=REPT(RIGHT(A1),3),A1,IF(AND(LEFT(RIGHT(A1,4),2)=REPT(LEFT(RIGHT(A1,4)),2),RIGHT(RIGHT(A1,4),2)=REPT(RIGHT(RIGHT(A1,4))...