title: How to merge rows in a column into one cell in excel?
body: <p>E.g </p>
  
  <pre><code>A1:I
  A2:am
  A3:a
  A4:boy 
  </code></pre>
  
  <p>I want to merge them all to a single cell "Iamaboy"<br>
  This example shows 4 cells merge into 1 cell however I have many cells (more than 100), I can't type them one by one using <code>A1 &amp; A2 &amp; A3 &amp; A4</code> what can I do?</p>