| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
