如果你的数据都是两位数的话,可以用公式==TEXT(A1&B1&C1&D1,REPT("00\,",COUNT(A1:D1)-1)&"00")
忘了从小到大!!
=TEXT(IF(ISNUMBER(SMALL(A1:D1,1)),SMALL(A1:D1,1),"")&IF(ISNUMBER(SMALL(A1:D1,2)),SMALL(A1:D1,2),"")&IF(ISNUMBER(SMALL(A1:D1,3)),SMALL(A1:D1,3),"")&IF(ISNUMBER(SMALL(A1:D1,4)),SMALL(A1:D1,4),""),REPT("00\,",COUNT(A1:D1)-1)&"00")