View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad[_12_] Brad[_12_] is offline
external usenet poster
 
Posts: 1
Default 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.