CODEWITHSUNDEEP
excelexcel-2007worksheet-function
thechoosenone
thechoosenone

Reputation: 145

How to remove a particular word in an Excel cell?

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

Example: if

Upvotes: 4

Views: 81891

Answers (3)

WaNgeL
WaNgeL

Reputation: 198

Try this formula for range of words:

=TRIM(SUBSTITUTE(A1,INDEX($B$1:$B$56,IF(ISNA(MATCH(FALSE,ISERR(FIND($B$1:$B$56,A1)),FALSE)),0,MATCH(FALSE,ISERR(FIND($B$1:$B$56,A1)),FALSE)),1),""))

Upvotes: 0

Shaya
Shaya

Reputation: 31

Just use the Replace function. leave " replace with" blank

Upvotes: 3

Doug Glancy
Doug Glancy

Reputation: 27478

Use the Substitute function:

=SUBSTITUTE(A1,B1,"")

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

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

Upvotes: 14

Related Questions