title: Format text output for XLS import
body: <p>I have a db table with user data. One of the columns contains comments. I am trying to format my data to pass to a class for output in XLS and CSV. Every field is working great but when it comes to comments I am having the hardest time to get it to work in XLS. I was able to make it work in CSV output by stripping all line breaks and encoding HTML characters:</p>
  
  <pre><code>$comm = htmlspecialchars(str_replace(array("\r\n", "\r", "\n"), "", $tx-&gt;comm));
  </code></pre>
  
  <p>What can I possibly do to make it work with XLS???</p>