【有图】excel表格中同一个表格里面如何提取两个单元格里面相同的数字到另外一个单元格

Question

如上三个单元格
想把单元1和单元2两个单元各种同一行，相同的数字提取出来，然后放入黄色的单元格里

Answer 1

假如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(FIND(4,A1)),ISNUMBER(FIND(4,B1))),4,"")&IF(AND(ISNUMBER(FIND(5,A1)),ISNUMBER(FIND(5,B1))),5,"")&IF(AND(ISNUMBER(FIND(6,A1)),ISNUMBER(FIND(6,B1))),6,"")&IF(AND(ISNUMBER(FIND(7,A1)),ISNUMBER(FIND(7,B1))),1,"")&IF(AND(ISNUMBER(FIND(8,A1)),ISNUMBER(FIND(8,B1))),8,"")&IF(AND(ISNUMBER(FIND(9,A1)),ISNUMBER(FIND(9,B1))),9,"")&IF(AND(ISNUMBER(FIND(0,A1)),ISNUMBER(FIND(0,B1))),0,"")
公式有点长，但是可以解决问题，还不用考虑数字的长度