excel表格数据排序 第一列是1234567,第二列是12457,如何让第二列和第...答:C1=CONCATENATE(IF(ISNUMBER(FIND("1",A1))*ISNUMBER(FIND("1",B1)),"1",""),IF(ISNUMBER(FIND("2",A1))*ISNUMBER(FIND("2",B1)),"2",""),IF(ISNUMBER(FIND("3",A1))*ISNUMBER(FIND("3",B1)),"3",""),IF(ISNUMBER(FIND("4",A1))*ISNUMBER(FIND("4",B1)),"4","")...