với ô A1 chứa dữ liệu nhé, bạn test xem có lỗi trường hợp nào không, ctrl + Shift + Enter nhé:
=IF(ISNUMBER(VALUE(RIGHT(A1;1)));RIGHT(A1;LEN(A1)-LARGE(IF(ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("1:"&LEN(A1)-1));1)))<>ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("2:"&LEN(A1)));1)));ROW(INDIRECT("1:"&LEN(A1)-1)));1));MID(A1;LARGE(IF(ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("1:"&LEN(A1)-1));1)))<>ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("2:"&LEN(A1)));1)));ROW(INDIRECT("2:"&LEN(A1))));2);LARGE(IF(ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("1:"&LEN(A1)-1));1)))<>ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("2:"&LEN(A1)));1)));ROW(INDIRECT("2:"&LEN(A1))));1)-LARGE(IF(ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("1:"&LEN(A1)-1));1)))<>ISNUMBER(VALUE(MID(A1;ROW(INDIRECT("2:"&LEN(A1)));1)));ROW(INDIRECT("2:"&LEN(A1))));2)))