Hi John,

What version of XL are you using? Certainly XL 2000 doesn't exhibit the
behaviour you mention. For me XL correctly ignores the CR-LF (and for that
matter commas etc) that appear within quotes.

Regards,

Peter Beach

"John A Grandy" wrote in message
...
I have a text-file I wish to import into an Excel spreadsheet.

This file's data-fields are comma-separated. Data-fields which contain
text
are quote-delimited .... but the text-data-fields can contain CR-LF.

Excel's Data Get External Data Import Text File menu option will see
each such CR-LF as starting a new row -- which I don't want.

Has anyone worked-up a solution for this kind of import problem ?