取每箱之前数字與單位 (10919)

B2=LOOKUP(1,0/MID(A2,FIND("/箱",A2)-ROW($2:$9),ROW($1:$8)),MID(A2,FIND("/箱",A2)-ROW($2:$9),ROW($2:$9)))

另解=-LOOKUP(1,-MID(A2,FIND("/箱",A2)-ROW($2:$9),ROW($1:$8)))&MID(A2,FIND("/箱",A2)-1,1)