excel怎么将单元格中字符串按大小排序(最好是公式)答:为方便设计公式,用多列得到排序后的数据,如图:B1公式:(公式比较长)=INDEX(TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",100)),ROW($1:$9)*100-99,100)),MATCH(SMALL(MMULT(N(TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",100)),ROW($1:$9)*100-99,100))>TRANSPOSE(TRIM(MID(SUBSTITUTE...