title: How can I concat cellvalues with new line in MS Excel?
body: <p>In excel I can introduce a new line inside a cell with a <code>[alt enter]</code></p>
  
  <pre><code>Boo[alt enter]Far
  </code></pre>
  
  <p>results in:</p>
  
  <pre><code>Boo
  Far
  </code></pre>
  
  <p>Now <code>A1</code> contains <code>Boo</code>, <code>A2</code> contains <code>Far</code>. How can I display these values in <code>A3</code> separated with a new line?</p>
  
  <pre><code>A3=A1[alt enter]&amp;B1
  </code></pre>
  
  <p>results in BooFar</p>
  
  <pre><code>A3=A1&amp;[alt enter]B1
  </code></pre>
  
  <p>results in BooFar</p>
  
  <p>How can I get</p>
  
  <pre><code>Boo
  Far
  </code></pre>
  
  <p>By using cell references?</p>