title: VBA - Inserting a space between concatenated cells
body: <p>This code works for me. However, in the destination cell, I'd like a space between A2 and B2's values:</p>
  
  <pre><code>For j = 1 To lastRow3
      If ws.Range("A" &amp; j) = "OKUMA LATHE" Then
          Cells(j, lastCol2 + 2).Formula = "=$A2&amp;$B2"
      End If
  Next j
  </code></pre>
  
  <p>What's a boy to do? Everything I try gives me a compile error...</p>