补齐較長的前面字元 (11041)

 

C1=A1

C2:C14=LEFT(LOOKUP(1,0/(FIND(".",A2&".")<FIND(".",C$1:C1&".")),C$1:C1),FIND(".",LOOKUP(1,0/(FIND(".",A2&".")<FIND(".",C$1:C1&".")),C$1:C1)&".")-(FIND(".",A2&".")))&A2

另解C2=LEFT(C1,LEN(INT(C1))-LEN(INT(A2)))&A2