title: VBA String Spaces: Preferred Method?
body: <p>When concatenating strings, there are multiple valid methods of inserting spaces.</p>
  
  <p><strong>Space Function:</strong></p>
  
  <pre><code>Print "A" &amp; Space(1) &amp; "B"
  A B
  </code></pre>
  
  <p><strong>VS</strong></p>
  
  <p><strong>Quotes:</strong></p>
  
  <pre><code>Print "A" &amp; " " &amp; "B"
  A B
  </code></pre>
  
  <p><strong>VS</strong></p>
  
  <p><strong>Chr:</strong></p>
  
  <pre><code>Print "A" &amp; Chr(32) &amp; "B"
  A B
  </code></pre>
  
  <hr>
  
  <p>All three methods yield the same result.  The only place where I found Space beneficial was when using a variable for the number of spaces.</p>
  
  <pre><code>Space( &lt;expression of number - len(var)&gt; )
  </code></pre>
  
  <p>Can anyone provide any insight on why one method is better than another?</p>