Tab delimited text problems within Excel

  • Thread starter Thread starter Andrew Lewis
  • Start date Start date
A

Andrew Lewis

When opening a tab delimited file within excel I am
experiencing problems.

The file's last column is blank, which is needed, but
when I open it within excel it recognises that the column
exists for the first 15 rows then it doesn't recognises
the column when saving back as a text file..

Any ideas?
 
A lot of programs don't need the tab if there is nothing in the values.

But if your program does, how about putting something in that last column that
you want.

Just put a single apostrophe (') in that last column of each row and excel will
understand what you want.
 
Back
Top