title: How do I concatenate cell values and text together using Excel VBA?
body: <p>I have a repetitive task I'd like to automate instead of using the =Concatenate function all the time. Here's my code so far:</p>
  
  <pre><code>Cells(2, 5).Value = Cells(2, 1).Value&amp;" - "&amp;Cells(2, 2).Value
  </code></pre>
  
  <p>Unfortunately this results in the "Compile error: Expected: end of statement" error, which highlights the " - ". How can I sandwich that text, " - ", between those two values?</p>