Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save As .XML, not exporting blank cells | Excel Discussion (Misc queries) | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
Pivot table blank/empty cells | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) |