CANNOT Import comma delimted, quote qualifed text file into Excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can NOT import a simple comma delimited file below in to Excel, althought I
used " as text qualifier, and COMMA as delimiter. Excel (version 2003)
persistenly parse it as having 3 fields rather than having only 2 fields.

"Income - $10,000 - $19,999", "Income - $20,000 - $29,999"

Could you please enlighten me? Thanks!
 
all the commas are throwing it off, if you check comma and space, it will
work for that example, but there always has to be a space after the comma for
it to work
 
I have the same problem. It is comma quote delimited text containing three
fields where the middle field can contain commas within the quotes.

"OR", "OR - Measurement warning, re-analyze.", "true"
This should be three fields, not four. If I tell it comma and space are the
delimiters it seems to work but that makes very little sense
 
Back
Top