title: if else statement where the condition is to match with the subtext of a text
body: <p>I want my condition to hold true if I find the string "john" in my cell .. and the cell value could be Mr John or John Carter. And both these scenarios should give a true value to my condition.</p>
  
  <p>I tried the below code. Didn't work:</p>
  
  <pre><code>If ActiveCell.Value = "Benchmark report " &amp; "*"
  </code></pre>