Finding words in Excel Cells

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Hello,
I'd like to scan a column for any word that's in a list in another sheet and put a code (e.g. "A") on the cell next to it each time it finds it. In this case, the word might be by itself or in the middle of a sentence.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
This thread should give you a very good start

https://ccm.net/forum/affich-606042-excel-vba2010-select-cells-between-2-keywords?full
This is almost It, Unfortunately only works when both columns contain lists of one word per cell.

=IF(COUNTIF($M:$M,D2)>=1,"Destroy","")

D equals my column of Titles containing many words M is my list of keywords.

I need to look in a column of key words (One per Cell) and if any of the keywords appear in a cell containing many words The letter D will appear in an adjacent cell.

Many Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Have you read this part of thread

https://ccm.net/forum/affich-606042-excel-vba2010-select-cells-between-2-keywords?full#10