更新时间:2023-10-27 15:48:58
尽管必须有更精细"的解决方案,但快速的解决方案(只要要替换的单词的单元格数量不太长),就会是:
Although there must be 'nicer' solutions, a quick solution (as long is the number of cells with the words you want replaced is not too long), would be:
=ArrayFormula(regexreplace(regexreplace(regexreplace(A1:A; List!A1; List!B1); List!A2; List!B2); List!A3; List!B3))