二組數字 依序結合 提取 (14008)

C4:L4=TEXT(SUMPRODUCT(MID($B3:$B4,COLUMN(A1),1)*{10;1}),0&0)

另解=TEXT(MMULT({10,1},MID($B3:$B4,COLUMN(A1),1)*1),0&0)

另解=MID(TEXT($B3,TEXT($B4,REPT("!0!!0",10))),COLUMN(A1)*2-1,3)

另解=MID($B$3,COLUMN(A1),1)&MID($B$4,COLUMN(A1),1)