取最大最小数字結合 (9768)

G6{=IF(COUNT(FIND(ROW($1:$9),C6))<2,0&LEFT(C6),SUM(PERCENTILE(IFERROR(MID(C6,ROW($1:$9),1)*1,""),{0,1})*{10,1}))

另解{=IF(COUNT(FIND(ROW($1:$9),C6))>1,SUM(SMALL(--MID(REPT(C6,9),ROW($1:$9),1),{1,9})*{10,1}),0&LEFT(C6))

另解{=IF(MOD(C6,REPT(1,LEN(C6))),SUM(SMALL(--MID(REPT(C6,9),ROW($1:$9),1),{1,9})*{10,1}),0&LEFT(C6))