...提取两个单元格里面相同的数字到另外一个单元格答:假如a1=156165464,b1=14544454 在c1中显示相同数字,则c1中复制如下公式 =IF(AND(ISNUMBER(FIND(1,A1)),ISNUMBER(FIND(1,B1))),1,"")&IF(AND(ISNUMBER(FIND(2,A1)),ISNUMBER(FIND(2,B1))),2,"")&IF(AND(ISNUMBER(FIND(3,A1)),ISNUMBER(FIND(3,B1))),3,"")&IF(AND(ISNUMBER(...