删除最后數字 (9533)

C2=LEFT(B2,LEN(B2)-LEN(-LOOKUP(1,-RIGHT(B2,ROW($1:$5)))))

另解=LOOKUP(1,0/ISERR(-RIGHT(LEFT(B2,ROW($1:$99)))),LEFT(B2,ROW($1:$99)))