title: Excel: Searching for multiple terms in a cell
body: <p>I use this handy equation to search for a term inside of a cell in excel.</p>
  
  <pre><code>=IF(ISNUMBER(SEARCH("*Gingrich*",C1)),"1","")
  </code></pre>
  
  <p>This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1.</p>
  
  <p>All I'd like to do is search for more than one term at a time. Anyone know how to add an OR function into this so I can search for Gingrich OR Obama OR Romney etc... ?</p>