Exporting a worksheet with blank/empty cells
I have a worksheet with 10,000 rows and 10 columns. In one of those columns
about 25% of the cells are empty. When I export the worksheet in a tab
delimited file those blank cells are simply omitted, so in those cases the
output record only has nine fields.
I need either to put something (the data in the column is numeric but always
=0) to indicate a blank (say -1) or to find some way to make the data export
put in two consecutive tabs with a blank between them representing the blank
cell.
Either solution would be OK, but I sort of prefer filling in the fields.
--
Thanks for your help - jjk98
|