拆分以中間數字 計三部分 (14578)

(先)D1{=RIGHT(A1,MATCH(1=0,ISERR(-LEFT(RIGHT(A1,ROW($1:$9)))),)-1)

(次)C1{=RIGHT(LEFT(A1,LEN(A1)-LEN(D1)),MATCH(1=1,ISERR(-MID(A1,FIND(D1,A1)-ROW($1:$29),1)),)-1)

(後)B1=SUBSTITUTE(SUBSTITUTE(A1,C1,),D1,)