ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Commas generated in csv files for blank rows in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/192030-commas-generated-csv-files-blank-rows-excel-2007-a.html)

Grasshopper

Commas generated in csv files for blank rows in Excel 2007
 
Salutations to the wise and experienced -

In previous versions of Excel, worksheets with blank rows saved as CSV
resulted in those blank rows creating only line breaks ( carriage returns) in
the exported file. Now it seems like a blank row results in a row of commas
(one for each column of data). Is there a switch, setting, tweak, to get the
old (Excel 97 to 2003) behavior to work in Excel 2007? I really need those
blank lines in the resulting file. I appreciate any assistance you could
provide.


All times are GMT +1. The time now is 10:05 PM.

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