图片是示范的2个词组,可以替换若干个词组谢谢!
B2单元格公式=SUBSTITUTE(SUBSTITUTE(A2,"23","2甲3"),"冰点","冰丙点")
下拉公式。 如图:(如果还要新增其它替换,就往外一层一层套上去,如:新增“云南”替换成“河阳”,公式变成=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"23","2甲3"),"冰点","冰丙点"),"云南","河阳")
在B2单元格输入以下公式,然后向下填充公式
=IF(ISNUMBER(FIND("23",A2)),SUBSTITUTE(A2,"23","2甲3"),IF(ISNUMBER(FIND("冰点",A2)),SUBSTITUTE(A2,"冰点","冰丙点"),A2))
详见附图示例