title: How to check if cell contains wildcard asterisk (*) character
body: <p><strong>Consider the following two formulas:</strong></p>
  
  <pre><code>=IF(SEARCH("*", A1), "true", "false")
  
  =IF(SEARCH(CHAR(42), A1), "true", "false")
  </code></pre>
  
  <p>I am using this to try and detect if a cell contains a <strong><code>*</code></strong> character, but this returns "true" for all cells. I can only assume that Excel sees <strong><code>*</code></strong> as a wildcard maybe.</p>
  
  <p>How do you detect the existence of a <strong><code>*</code></strong> in Excel?</p>