Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save as CSV not saving the same from Excel 2007 then in Excel 2003
If I take an Excel file and Save it as a CSV in Excel 2003 the blank rows
from the Excel file show up on the CSV as blank rows (no commas show in that row) But when I save the same file in Excel 2007 (which we recently upgraded) the blank rows from Excel show up as about 15 commas on the CSV file. There are also other rows of data in the CSV file that have 5-10 extra commas appended to the end. Is there an option in Excel 2007 to save as CSV file but exclude blank rows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save as CSV not saving the same from Excel 2007 then in Excel 2003
I can confirm that xl 2003 saves blank rows as blank rows while xl2007 saves
them with commas and seems to add a few rows at the end In an experiment, I did a Data|Filter and deselected the blank rows, then did Copy & Paste to new worksheet before saving a CSV. Empty rows are gone as expected. You could record a subroutine to do this best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Craig" wrote in message ... If I take an Excel file and Save it as a CSV in Excel 2003 the blank rows from the Excel file show up on the CSV as blank rows (no commas show in that row) But when I save the same file in Excel 2007 (which we recently upgraded) the blank rows from Excel show up as about 15 commas on the CSV file. There are also other rows of data in the CSV file that have 5-10 extra commas appended to the end. Is there an option in Excel 2007 to save as CSV file but exclude blank rows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving with excel 2007 and oppening with excel 2003 | Excel Discussion (Misc queries) | |||
Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
Unable to save modified Excel 2003 worksheets using Excel 2007 | Excel Discussion (Misc queries) | |||
Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
Excel 2003: File->Close without saving changes (save menu does no. | Excel Discussion (Misc queries) |