B2=LEFT(SUBSTITUTE(A2,0,)&REPT(0,9),LEN(A2))
C2=SUBSTITUTE(A2,0,)&REPT(0,LEN(A2)-LEN(SUBSTITUTE(A2,0,)))
B12{=IFERROR(RIGHT(SMALL(IFERROR(TEXT(MID($A12,ROW($1:$9),1),"[=]999!0;0")+ROW(1:9)/1%,""),COLUMN(A1)))&C12,"")
另解{=SUM(RIGHT(LARGE(IFERROR(MID(A2,ROW($1:$9),1)/10^ROW($1:$9),10),ROW($1:$9)))*10^(9-ROW($1:$9)))
另解{=INT(NPV(-0.9,MOD(LARGE(TEXT(MID(A2,ROW($1:$9),1),ROW($1:$9)&"0;;990;!0")/1,ROW($1:$9)),10))/10)
留言
張貼留言