title: Excel VBA - delete string content up to *word*
body: <p>I'm trying to delete string content up to a certain word contained within the string. For example</p>
  
  <pre><code>"Emily has wild flowers. They are red and blue."
  </code></pre>
  
  <p>I'd like to use VBA in order to replace that with</p>
  
  <pre><code>"They are red and blue."
  </code></pre>
  
  <p>i.e. remove all the content up to the word "They". I don't know the string content and the number of characters contained in it.</p>
  
  <p>I'm not sure how to do this and I'd really appreciate your help!</p>