title: Concatenating CHAR(10) in Fomula ignores line break
body: <p>quick question:</p>
  
  <p>A Cell with formula</p>
  
  <pre><code>="a" &amp; CHAR(10) &amp; "b"
  </code></pre>
  
  <p>will just show <code>ab</code> (single line in cell).
  Why does it not show:</p>
  
  <p><code>a
  b</code> </p>
  
  <p>(2 lines in cell)?</p>
  
  <p>My understanding is, that CHAR(10) is the "intra-cell-new-line character" (on Windows at least).
  What am I missing?</p>
  
  <p>I'm using Office 365 ProPlus on Win10.</p>