假设A1=123456 B1=036987 (A1和B1的单元格格式为文本猛旦，否则B1=036987前面的0不显示)
输入下面数组公式，按组旁知雀合键运早 Ctrl+Shift+回车 结束
=IF(ISERR(FIND(0,A1))+ISERR(FIND(0,B1))=1,0,)&SUBSTITUTE(SUM(IF(ISERR(FIND({1,2,3,4,5,6,7,8,9},A1))+ISERR(FIND({1,2,3,4,5,6,7,8,9},B1))=1,{1,2,3,4,5,6,7,8,9},)*10^{8,7,6,5,4,3,2,1,0}),0,)
