title: Combine multiple cells into one in excel with macro?
body: <p>I have a similar question to this one:</p>
  
  <p><a href="https://stackoverflow.com/questions/621862/merge-the-contents-of-2-cells-into-another-3rd-cell-using-vba-in-excel">Merge the contents of 2 cells into another 3rd cell using VBA in Excel</a></p>
  
  <p>But I want to combine a range of cells within a column, eg A2:A50. Sometimes I have over 300 cells to be combined into one. Values are text. Is there any way to modify this macro so that it works on a range instead of just two cells?</p>
  
  <p>Thanks!</p>