How to ignore blank cells while concatenating cells in Excel
<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>