數據後面數字 +數字 (12580)

D2=LOOKUP(1,0/ISERR(-(MID(B2,ROW($1:$9),1)&1)),LEFT(B2,ROW($1:$9)))&-LOOKUP(1,-RIGHT(B2,ROW($1:$9)))+C2

另解{=LEFT(B2,MIN(FIND(ROW($1:$9)-1,B2&1/17))-1)&-LOOKUP(1,-RIGHT(B2,ROW($1:$9)))+C2