如何删除Excel单元格中的特定单词? [英] How to remove a particular word in an Excel cell?

问题描述

如何删除Excel中另一个单元格中一个单元格的列中的特定单词.

How do you remove a particular word in a column of one cell that's in another cell in Excel.

示例:如果

• A1 = *1603 Ad street New York*，
• B1 = *New York*
• 然后在C1中我想要= *1603 Ad street*

• A1 = *1603 Ad street New York*,
• B1 = *New York*
• then in C1 I want = *1603 Ad street*

推荐答案

使用替代功能:

=SUBSTITUTE(A1,B1,"")

根据brettdj的建议，添加了TRIM以消除前导或尾随空格:

Per brettdj's suggestion, added TRIM to get rid of leading or trailing spaces:

=TRIM(SUBSTITUTE(A1,B1,""))

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