C2=-LOOKUP(9,-MID(A2,MIN(FIND({" ","x"},A2&" x"))-ROW($1:$9),ROW($1:$9)))
另解=-LOOKUP(9,-RIGHT(LEFT(A2,MIN(FIND({" ","x"},A2&" x")-1)),ROW($1:$9)))
另解=-LOOKUP(1,-RIGHT(LEFT(A2,FIND("x",SUBSTITUTE(A2," ","x"))-1),ROW($1:$9)))
另解=LOOKUP(1,-RIGHT(REPLACE(A2,MIN(FIND({" ";"x"},A2&" x")),99,),{1;2;3;4}))
留言
張貼留言