title: How to ignore blank cells while concatenating cells in Excel
body: <p>I am trying to concatenate multiple cell values in one cell as below:</p>
  
  <pre><code>Column A  Column B  Column C  Column D  Column E  Column F
  Blank     Text 1    Text 2    Blank     Text 3
  </code></pre>
  
  <p>I am concatenating values from A to E</p>
  
  <p>My formula is </p>
  
  <pre><code>A1&amp;CHAR(10)&amp;B1&amp;CHAR(10)&amp;C1&amp;CHAR(10)&amp;D1&amp;CHAR(10)&amp;E1
  </code></pre>
  
  <p>What I am getting in Column F is</p>
  
  <pre><code>Blank
  Text 1
  Text 2
  Blank
  Text 3
  </code></pre>
  
  <p>What I am looking for is</p>
  
  <pre><code>Text 1
  Text 2
  Text 3
  </code></pre>
  
  <p>Can anyone help me with the right formula?</p>