假如，两个数分别在A1和B1=IF(ISERR(FIND("0",A1&B1)),"",0)&SUBSTITUTE(MMULT(IF(ISNUMBER(FIND({"1","2","3","4","5","6","7","8","9"},A1&B1)),{1,2,3,4,5,6,7,8,9},),10^{8;7;6;5;4;3;2;1;0}),0,)如果数字内含有“0”，结果是：0123456789，由小到大排列。如果不会有“0”，或结果不需要显示“0”=SUBSTITUTE(MMULT(IF(ISNUMBER(FIND({"1","2","3","4","5","6","7","8","9"},A1&B1)),{1,2,3,4,5,6,7,8,9},),10^{8;7;6;5;4;3;2;1;0}),0,)就可以了。