Hi
My aim is to export certain data from a spreadsheet to CSV. I need to ensure that there are no blank records in the CSV; any such records would have to be manually deleted before the CSV can be used for import in the next stage.
I cannot seem to be able to achieve this. If, in the destination sheet, I look for blank cells using ^G | Special | Blank, a range is selected. No matter what I try to delete (Cells, Rows, Columns) the same range is shewn as blank.
How can I achieve a clean CSV ?
My aim is to export certain data from a spreadsheet to CSV. I need to ensure that there are no blank records in the CSV; any such records would have to be manually deleted before the CSV can be used for import in the next stage.
I cannot seem to be able to achieve this. If, in the destination sheet, I look for blank cells using ^G | Special | Blank, a range is selected. No matter what I try to delete (Cells, Rows, Columns) the same range is shewn as blank.
How can I achieve a clean CSV ?
