Excel: If cell contains 1 or more keywords, change value of a different cell - Stack Overflow

Is there a limit on the number of possible words in the string? Splitting them and searching is easy. However if there are a large number you have to write a very long formula to split each word out. – paulmorriss Mar 22 '11 at 16:56

stackoverflow.com