在B1中输入:=IF(IF(ISERROR(FIND(4,A1,1)),A1,"")=A1,IF(ISERROR(FIND(7,A1,1)),A1,""),IF(ISERROR(FIND(4,A1,1)),A1,""))在c1中输入:=IF(RIGHT(A1,1)="8",A1,"")在D1中输入:=IF(AND(RIGHT(A1,1)=MID(A1,LEN(A1)-1,1),RIGHT(A1,1)MID(A1,LEN(A1)-2,1)),A1,"")在E1中输入:=IF(AND(RIGHT(A1,1)=MID(A1,LEN(A1)-1,1),RIGHT(A1,1)=MID(A1,LEN(A1)-2,1)),A1,"")将B1 ...
|