更新时间2018-07-02 04:50:47
A列 B列 C列
0123456789 1256 034789
0123456789 0123 456789
=IF(ISERROR(FIND(MID($A1,COLUMN(A1),1),$B1)),MID($A1,COLUMN(A1),1),"")
=CONCATENATE(D1,E1,F1,G1,H1,I1,J1,K1,L1,M1)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,MID(B1,1,1),),MID(B1,2,1),),MID(B1,3,1),),MID(B1,4,1),)