title: Import txt file with line breaks into Excel
body: <p>while working on an export to Excel I discovered the following problem.</p>
  
  <p>If you create a table where one cell has a line break and you save the document as a txt file it will look like this:</p>
  
  <pre><code>"firstLine&lt;LF&gt;secondLine"&lt;TAB&gt;"secondColoumn"
  </code></pre>
  
  <p>When I open this file in Excel the line break is gone and the first row has only one cell with the value <em>firstLine</em></p>
  
  <p>Do you know if it is somehow possible to keep the line breaks?</p>
  
  <p>EDIT: Applies to Excel2010. Don't know if other versions behave different.</p>
  
  <p>EDIT2: Steps to reproduce:</p>
  
  <ol>
  <li>Open blank excel sheet</li>
  <li>Enter text (first column with line break, second colum not important)</li>
  <li>Save as Unicode Text (txt) // all other txt don't work as well</li>
  <li>Close Excel file</li>
  <li>File->Open</li>
  <li>No changes in the upcoming dialog.</li>
  </ol>
  
  <p>The excel file has now 2 rows which is wrong.</p>