title: How to remove spaces in a string after a certain character?
body: <p>I'm just wondering if there is a way to replace all blank spaces after a certain character in a string.  Basically a string like;</p>
  
  <pre><code>str = "This is a test - 1, 2, 3, 4, 5"
  </code></pre>
  
  <p>I would like essentially remove all of the spaces after the '-'.  I understand how to do the </p>
  
  <pre><code>replace(str," ","") 
  </code></pre>
  
  <p>but that will remove every space, and I want to keep the 'This is a test -" intact for readability to the user.  I have used </p>
  
  <pre><code>Instr(str,"-") 
  </code></pre>
  
  <p>to get the position of that character but do not know how to then enact the replace function on the rest of the string starting from that point.</p>