excel如何将多个字符批量替换成同一字符？

Question

例如同时将“CCAD”“UYRF”“ONVF”替换成“ABC”，公式该怎样写？

Answer 1

在B1中输入或复制粘贴下列公式
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"CCAD","ABC"),"UYRF","ABC"),"ONVF","ABC")
下拉填充