Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel puts quotes around cells with commas in tab delimited files | Setting up and Configuration of Excel | |||
Hiding the results of a formula generated from a blank cell | Excel Discussion (Misc queries) | |||
Excel should warn about commas when saving .csv files. | Excel Discussion (Misc queries) | |||
Excel - Find and Replace from rows to separation by commas | Excel Discussion (Misc queries) | |||
Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) |