K2=IF(LEN(J2)<MIN(FIND(ROW(A$1:A$10)-1,J2&1234567890)),"",LOOKUP(9E+307,--MID(J2,MIN(FIND(ROW($A$1:$A$10)-1,J2&1234567890)),ROW(A$1:A$10))))
数组公式,ctrl+shift+enter结束,下拉公式,单元格内不能有多个数,只能提取一个数,下拉公式
或不用数组公式
K2=IF(ISNA(-LOOKUP(,-MID(J2,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},J2)),FIND({1,2,3,4,5,6,7,8,9,0},J2),LEN(J2))),ROW(A$1:A$10)))),"",-LOOKUP(,-MID(J2,MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},J2)),FIND({1,2,3,4,5,6,7,8,9,0},J2),LEN(J2))),ROW(A$1:A$10))))