Question

用excel，如我（1,2,3,4）爱（5,6,7,8）你（9,10,11,12）

A1为我，爱，你。。B1对应1,2,3,4,5,6,7,8,9,10,11,12,B1为爱则B2为5,6,7,8
C1为我，爱，，则C2为1,2,3,4,5,6,7,8,

Answer 1

见截图

讲对照表放到DE列

B1输入

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,$D$1,$E$1),$D$2,$E$2),$D$3,$E$3)

公式下拉

Answer 2

B1输入：

=IF(COUNTIF(A1,"*我*"),"1,2,3,4,","")&IF(COUNTIF(A1,"*爱*"),"5,6,7,8，","")&IF(COUNTIF(A1,"*爱*"),"9,10,11,12,","")