Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point Me. Searching strings for lists of keywords
How would you go about this? Column of cells of text. I want to seach each cell for a list of words and, if a word is found, put a value in a cell. Example. If text contains any of the words Chevy, Buick, Caddilac, i'd like to out that word in an ajacent cell for indexing purposes. The list of words will be pretty long so nested if's are not a good approach. Thanks for any suggestions.
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for strings in a column | Excel Worksheet Functions | |||
Is there a formula for searching for any one of a list of strings? | Excel Worksheet Functions | |||
Searching for codes in text strings | Excel Worksheet Functions | |||
Searching for Substrings Within Strings | Excel Discussion (Misc queries) |