title: How to remove blank lines within a cell in Excel?
body: <p>I have multiline text in a single Excel cell. I want to remove all blank lines from that text.  I must be clear that I do not want to remove all line breaks.</p>
  <p><strong>Example A:</strong></p>
  <pre><code>There is a place where the sidewalk ends
  And before the street begins,
  And there the grass grows soft and white,
  
  And there the sun burns crimson bright,
  And there the moon-bird rests from his flight
  
  To cool in the peppermint wind.
  </code></pre>
  <p>...should translate to:</p>
  <pre><code>There is a place where the sidewalk ends
  And before the street begins,
  And there the grass grows soft and white,
  And there the sun burns crimson bright,
  And there the moon-bird rests from his flight
  To cool in the peppermint wind.
  </code></pre>
  <p><strong>Example B:</strong></p>
  <pre><code>
  
  
  
  
  There is a place where the sidewalk ends
  And before the street begins,
  And there the grass grows soft and white,
  And there the sun burns crimson bright,
  And there the moon-bird rests from his flight
  
  To cool in the peppermint wind.
  
  
  
  </code></pre>
  <p>...should translate to:</p>
  <pre><code>There is a place where the sidewalk ends
  And before the street begins,
  And there the grass grows soft and white,
  And there the sun burns crimson bright,
  And there the moon-bird rests from his flight
  To cool in the peppermint wind.
  </code></pre>
  <p>I want to remove blank lines because:</p>
  <ul>
  <li><p>Viewing the spreadsheet, it may look like some cells are empty, but in reality they <em>do</em> have text after several empty lines;</p>
  </li>
  <li><p>I need to clean the data for import into another storage solution</p>
  </li>
  </ul>
  <p>Microsoft has some documentation on how to remove spaces in Excel.</p>
  <p>But it does not specifically describe a solution for removing blank lines:</p>
  <ul>
  <li><a href="https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41" rel="nofollow noreferrer">CLEAN function</a></li>
  <li><a href="https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9" rel="nofollow noreferrer">TRIM function</a></li>
  <li><a href="https://support.microsoft.com/en-us/office/top-ten-ways-to-clean-your-data-2844b620-677c-47a7-ac3e-c2e157d1db19" rel="nofollow noreferrer">Top ten ways to clean your data</a></li>
  </ul>