title: How to remove spaces in between text?
body: <p>Why trim is not working in VBA?</p>
  
  <pre><code>for i = 3 to 2000
  activesheet.cells(i,"C").value = trim(Activesheet.cells(i,"C").value)
  next i
  </code></pre>
  
  <p>It is unable to remove the spaces in between the text.</p>
  
  <pre><code> hiii              how ' even after trying trim the o/p is still these
   hiii              how
  </code></pre>
  
  <p>I need to remove the extra spaces so I found <code>Trim</code> to do it but it is not working while <code>ltrim</code> and <code>rtrim</code> are.</p>