...第二列是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","")...