D2=TEXT(SUM(MID(SUBSTITUTE(LEFT(A2,LEN(A2)-1),"-",REPT(" ",19)),{1,2,3}*19-18,19)*10^{5,3,0}),"0-00-000!#")
G2{=TEXT(LEFT(F2,FIND("-",F2)-1),REPT(0,MAX(FIND("-",F$2:F$13))-1))&"-"&TEXT(TRIM(MID(SUBSTITUTE(F2,"-",REPT(" ",19)),19,19)),REPT(0,MAX(FIND("-",MID(F$2:F$13,FIND("-",F$2:F$13)+1,9)))-1))&"-"&RIGHT(SUBSTITUTE(F2,"-",REPT(0,9)),MAX(LEN(TRIM(RIGHT(SUBSTITUTE(F$2:F$13,"-",REPT(" ",19)),19)))))
留言
張貼留言