title: Using SUBSTITUTE with wildcard characters
body: <p>To illustrate my issue, use the following simple example.</p>
  
  <p>I want to be able to replace any text that comes between "replace" and "that" to "it is done". For example, the two following strings:</p>
  
  <pre><code>blah blah blah replace this and that blah
  blah blah blah replace this and some other text and that blah
  </code></pre>
  
  <p>to this string</p>
  
  <pre><code>blah blah blah it is done blah
  </code></pre>
  
  <p>using the SUBSTITUTE function in excel using wildcard characters.</p>
  
  <p>This is the formula that I'm using:</p>
  
  <pre><code>=SUBSTITUTE("blah blah blah replace this and that blah","replace*that","it is done")
  </code></pre>
  
  <p>The formula isn't replacing the text, though, and evaluates to "blah blah blah replace this and that blah"</p>
  
  <p>What is going on?</p>