J
John A Grandy
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 ?
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 ?