如何从一个单元格中删除多个文本字符串? [英] How to remove multiple text strings from a cell?

问题描述

让我们说单元格A1包含:

Let's say the cell A1 contains:

Some fog eh Pop I've already heard the weather report Drive please Boy It's as thick as pea soup Not a soul around for miles Know what I think pop Perfect place for a murder Conversation like television set on honeymoon Unnecessary

我想删除单词 the ， I ，是， as ， a， for 和 on .

And I want to remove the words the, I, It's, as, a, for, and on from it.

似乎应该使用 REGEXREPLACE 或 SUBSTITUTE 函数:

SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

是否可以在search_for参数中插入多个值?我找不到关于此的任何文档...

Is there a way to insert multiple values in the search_for parameter? I can't find any documentation on this...

推荐答案

查看是否可行

=REGEXREPLACE(A1,"\s\b(the|I|It's|as|a|for|on)\b",)

这篇关于如何从一个单元格中删除多个文本字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！