title: import text file containing line breaks into excel
body: <p>I have a plain text file looking like this:</p>
  
  <pre><code>"some  
   text  
   containing  
   line  
   breaks"
  </code></pre>
  
  <p>I'm trying to talk <code>excel 2004 (Mac, v.11.5)</code> into opening this file correctly. I'd expect to see only one cell (A1) containing all of the above (without the quotes)...</p>
  
  <p>But alas, I can't make it happen, because Excel seems to insist on using the CR's as row delimiters, even if I set the text qualifier to double quote. I was sort of hoping that Excel would understand that those line breaks are part of the value - they are embedded in double quotes which should qualify them as part of the value. So my Excel sheet has 5 rows, which is not what I want.</p>
  
  <p>I also tried this Applescript to no avail:</p>
  
  <pre><code>tell application "Microsoft Excel"
      activate
      open text file filename ¬
      "Users:maximiliantyrtania:Desktop:linebreaks" data type delimited ¬
      text qualifier text qualifier double quote ¬
      field info {{1, text format}} ¬
      origin Macintosh with tab
  end tell
  </code></pre>
  
  <p>If I could tell Excel to use a row delimiter other than CR (or LF), well, I'd be a happy camper, but excel seems to allow the change of the field delimiter only, not the row delimiter.</p>
  
  <p>Any pointers?</p>
  
  <p>Thanks,</p>
  
  <p>Max 
  Excel's open</p>