title: How to reduce all whitespace in a string to single spaces?
body: <p>Using VB6 <em>without</em> any additional references such as Regex, how can I convert a string so that all whitespace in a string is reduced to single spaces?</p>
  
  <p>eg.</p>
  
  <pre><code>" A    B C D   E"
  </code></pre>
  
  <p>would be converted to </p>
  
  <pre><code>"A B C D E"
  </code></pre>