如何在excel列里边批量去除相同文字前边的某段文字答:假设数据在A列,则在B1输入 =IF(ISERROR(FIND("456",RIGHT(A1,LEN(A1)-FIND("456",A1)-2))),RIGHT(A1,LEN(A1)-FIND("456",A1)+1),RIGHT(RIGHT(A1,LEN(A1)-FIND("456",A1)-2),LEN(RIGHT(A1,LEN(A1)-FIND("456",A1)-2))-FIND("456",RIGHT(A1,LEN(A1)-FIND("456",A1)...