Excel saving as Tab Delimited

[Scott Miller]

When saving a spreadsheet as Tab Delimited, I get extra
lines in the file that I am trying to import. This is
because Excel is exporting all rows that have been
edited, even if they are now blank. Does anybody know of
a setting I can use so that now blank lines are saved?

Thanks!

Scott Miller

 

[Bernie Deitrick]

Scott,

I presume you mean a setting so that blank lines AREN'T saved...

In either case, no, there isn't a setting that controls this. Delete the
now-blank lines prior to export, or use a macro that does the export
precisely the way you want.

HTH,
Bernie
MS Excel MVP