前面數字提取 統一5位數 (14904)

C2=TEXT(LEFT(B2,LOOKUP(1,0/MID(B2,ROW($1:$9),1),ROW($1:$9))),"00000")

另解C2=TEXT(-LOOKUP(1,-LEFT(B2,ROW($1:$9))),"00000")