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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing delimiters after 15 records 3
Converting excel file to tab delimited (txt) file 1
Generate a TAB When Converting From Excel to Delimited Text 1
point as delimiter 1
tab delimited characters 1
Text-to-columns, but only 1st 2 & last delimiters 5
Puzzling quotes around text 2
Tab delimited text file import on double click 2

Back
Top