開頭 0 刪除 (14485)

C2{=MID(B2,MIN(FIND(ROW($1:$9),B2&1/17)),99)

F2{=IF(ISERR(-LEFT(E2)),LEFT(E2,MATCH(1=1,ISNUMBER(-MID(E2,ROW($1:$9),1)),)-1),"")&MID(B2,MIN(FIND(ROW($1:$9),B2&1/17)),99)