title: Combine text of multiple cells
body: <p>How to combine text of multiple cells for instance translate this excel formula to VBA code
  Cell <code>F3</code> should <code>=Q3&amp;"_"&amp;A3&amp;"_"&amp;D3&amp;"_"&amp;(ROUND(M3/1000,1))&amp;"k"</code></p>
  
  <p>But I would Like it to repeat in every instant so in <code>F99= Q99&amp;"_"&amp;A99&amp;"_"&amp;D99&amp;"_"&amp;(ROUND(M99/1000,1))&amp;"k"</code></p>
  
  <p>Using VBA Code:</p>
  
  <pre><code>For Each Cel In Range("A1:A100")   
  If Cel.Value &lt;&gt; "" Then Cel.Offset(0, 5).Value = *Excel Formula NEED* "Q3&amp;"_"&amp;A3&amp;"_"&amp;D3&amp;"_"&amp;(ROUND(M3/1000,1))&amp;"k""*
  </code></pre>
  
  <p>Saying that if value in column A insert text in same row Column E</p>