編碼 五種連結 (10771)

F2下拉=C$2&"-"&RIGHT(C$3)&TEXT(C$4,"00")&TEXT(C$5,"00")&TEXT(ROW(A1),"0000")

另解=C$2&-RIGHT(MMULT(100^{2,1,0},C$3:C$5),5)/1%%-ROW(A1)