title: Merge text from two cells in Excel into one with VBA
body: <p>I received many Excel files from a client. </p>
  
  <p>Their system extracted the data into a spreadsheet, but one column is having issues. If the text was too long, it would put the remaining text into the cell below it. </p>
  
  <p>This causes all the other fields in that row to be blank, except for the overflow. </p>
  
  <p>How can I merge cells at issue into one for all files I received? </p>
  
  <p>I uploaded a screen shot of the file as an example. Notice on row 8 that H8 is the only cell. That needs to be merged with H7. Not every row is at issue though.</p>
  
  <p><a href="https://i.stack.imgur.com/psm7j.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/psm7j.jpg" alt="enter image description here"></a></p>