C3=SUBSTITUTE(TEXT(SUM(LEN(TRIM(MID(SUBSTITUTE(A3,"-",REPT(" ",99)),{1,2,3}*99-98,99)))*10^{4,2,0}),"0-00-00"),"-0","-")
另解=FIND("-",A3)-1&"-"&(FIND("-",A3,FIND("-",A3)+1)-FIND("-",A3)-1)&"-"&LEN(MID(A3,FIND("-",A3,FIND("-",A3)+1)+1,99))
前面長度>9 有誤=SUBSTITUTE(TEXT(MID(NPV(99,LEN(TEXT({1,-1,0},""""&SUBSTITUTE(A3,"-",""";""")&""""))),3,6),"0-00-00"),"-0","-")
前面長度>9 有誤=SUBSTITUTE(TEXT(MID(NPV(99,LEN(TRIM(MID(SUBSTITUTE(A3,"-",REPT(" ",99)),{1,2,3}*99-98,99)))),3,6),"0-00-00"),"-0","-")
另解=FIND("-",A3)-1&"-"&LEN(TRIM(MID(SUBSTITUTE(A3,"-",REPT(" ",99)),99,99)))&"-"&LEN(TRIM(RIGHT(SUBSTITUTE(A3,"-",REPT(" ",99)),99)))
留言
張貼留言