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

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!
 
G

Guest

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
 
M

Mark

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing text with text qualifier 2
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Convert Excel to comma delimited text 2
Import of Text Delimited file into excell 1
Importing Comma delimited file 2
Importing Text file with Strange Delimiter 1
How can I save a file as a comma-delimited text file in Excel? 1
Import comma delimited text 2

Top