title: Excel VBA- remove part of the string
body: <p>I am trying to delete part of the string. For example<br>
  <code>mystring="site, site text, sales "</code></p>
  
  <p>I want to remove '<strong>site</strong>' from mystring. My required output is <strong>"site text, sales"</strong></p>
  
  <p>I use this line of code :</p>
  
  <pre><code>s1 = Replace(mystring, "site", "")
  </code></pre>
  
  <p>but i am getting <code>"text, sales"</code></p>
  
  <p>I am not sure how to do this and I'd really appreciate your help!</p>