ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No blank lines in text files (https://www.excelbanter.com/excel-discussion-misc-queries/43545-no-blank-lines-text-files.html)

Charlie Gotwald

No blank lines in text files
 
When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)

Charlie Gotwald

Oops, managed to send the same question twice! How can one delete a subject?

"Charlie Gotwald" wrote:

When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)



All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com