title: What delimiter should I use instead of a , so that excel would recognize it as a new column
body: <p>I'm wondering if I can manually do a search replace on my <code>,</code>s in my csv generator so that the file when named *.xls would open natively in Excel.</p>
  
  <p>I'm guessing that they just use a different delimiter? </p>
  
  <p>[EDIT] If I leave the <code>,</code> alone excel will open the file and treat the ,s as strings to draw, so EVERYTHING winds up in Column A with the commas in place. </p>
  
  <p>In other words</p>
  
  <p>abc, def, ghi</p>
  
  <p>which I want to turn up as</p>
  
  <pre><code>A   |  B   |   C
  abc | def  |  ghi
  </code></pre>
  
  <p>instead gets drawn as</p>
  
  <pre><code>A            |    B    | C
  abc, def, ghi|         |
  </code></pre>