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

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

"Feiming Chen" wrote:

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