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
