且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Google表格可以从列表中进行多次搜索和替换

更新时间: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))