後面編號補足三位數 (12347)

B2=SUBSTITUTE(A2,"-","-"&REPT(0,3-LEN(MID(A2,MATCH("-",MID(A2,{9,10,11},1),)+9,9))),3)

另解=SUBSTITUTE(A2,"-","-"&REPT(0,3-LEN(TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",99)),9)))),3)