View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jjk98 jjk98 is offline
external usenet poster
 
Posts: 14
Default 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