C
Craig
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?
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?