Previous Topic Next Topic

Finding words in Excel Cells

Closed
Sparky - 14 Dec 2011 à 09:55
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Dec 2011 à 18:07
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.



Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 Dec 2011 à 10:18
This thread should give you a very good start

https://ccm.net/forum/affich-606042-excel-vba2010-select-cells-between-2-keywords?full
Sparky
15 Dec 2011 à 05:52
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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Dec 2011 à 18:07
Have you read this part of thread

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

Similar discussions

Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses