title: Excel Search Formula only works for exact match
body: <p>I'm trying to use the search formula in Excel to check whether a column contains a string. However, I don't need the match to be exact. So f.i., if a cell in the column has abcd in it and while I'm searching for abc, I still want a value returned. Unfortunately at the moment I only get a value returned if I search for abcd exactly.</p>
  
  <p>The formula I use right now looks like this:</p>
  
  <pre><code>  =SEARCH("abc";A2:A8)
  </code></pre>
  
  <p>There's no value returned, even though A3 has "abcd" in it.</p>
  
  <p>Thanks in advance!</p>