title: How to concatenate text from a column into a new column? VBA Excel
body: <p>I'm new to <a href="/questions/tagged/vba" class="post-tag" title="show questions tagged 'vba'" rel="tag">vba</a> programming and I would like to work on a function to fix salutations in an excel file. </p>
  
  <p>To start, I would just like to append a <em>Dear "</em> to a name in the first column, and put this value in the next column, so that I would end up with the name in the first column and "Dear name" in the next column.</p>
  
  <p>The function I have so far, is putting <em>"Dear "</em> in the next column, but it is not appending that to the text in the first column. Could someone help me correct my code?</p>
  
  <pre><code>Sub letterSalutationFixer()
  
        Dim letterSalutationColumn As Range
        Set letterSalutationColumn = Columns(1)
  
         For Each Cell In letterSalutationColumn
              Cell.Offset(, 1).Value = "Dear " &amp; Cell.Text    
        Next
  
      End Sub
  </code></pre>
  
  <p><em>PS. I do realise that I don't necessarily need to do this programmatically since it doesn't take that long to do with the functions already available, but I eventually want to expand this to fix other data with more complexity - and just thought I could start with something simple.</em></p>
  
  <p>Many thanks in advance!</p>