title: VBA variable string concatenation
body: <p>I have a variable a = "C2"
  and variable b = "C3"</p>
  
  <p>I need to do something like</p>
  
  <pre><code>ws.Range("A2").Value = "=" &amp; a &amp;"" ""&amp; b
  </code></pre>
  
  <p>which should return:</p>
  
  <pre><code>=C2&amp;" "&amp;C3
  </code></pre>
  
  <p>in an excel formula however I cant seem to get this to work anyone have a solution??</p>