如在A1单元格里有505这三个数字,A2单元格里有312这三个数字,如何利用公式在B1单元格里排序成055,在B2单元格里排序成123,没有数字就不用排序
è§æ ·è¡¨æªå¾ï¼B1è¾å ¥
=REPT(0,LEN(A1)-LEN(SUBSTITUTE(A1,0,)))&SUM(SMALL(1*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),ROW(INDIRECT("1:"&LEN(A1))))*10^(LEN(A1)-ROW(INDIRECT("1:"&LEN(A1)))))
ä¸æå³å¯
追é®ä¸é¢é£ä¸ªå ¬å¼ä¸å¯¹åï¼æè¾å ¥å®ä»¥åå¾å°çç»ææ¯0500å300å
追çå¿äºè¯´äº
è¿æ¯æ°ç»å
¬å¼ï¼å
æä½CTRL+SHIFT,æåå车ï¼ä½¿å¾ç¼è¾æ å
¬å¼ä¸¤ç«¯åºç°è±æ¬å·{ }
å
¬å¼ä¸æ