I have an excel spreadsheet with some tabular data, when I save it as Tab Separated Values file (.txt) it also saves a few blank columns on the right.
I have to go and select the blank columns in the spreadsheet, delete them, and then re-save.
Deleting the column every time is not an option, since that's a major inconvenience for end user.
Any ideas?
p.s. I'm not looking for tips on training users to delete the columns, I'm looking for a setting in Excel that would prevent the blank columns from being saves to TSV (tab separated values) file.