Excel saving as Tab Delimited

  • Thread starter Thread starter Scott Miller
  • Start date Start date
S

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
 
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
 
Back
Top