I want to save an excel file as a tab delimite text file. But I found that the last column is always a tab. I don't want it. How can I do it?
Thanks
I want to save an excel file as a tab delimite text file. But I found that the last column is always a tab. I don't want it. How can I do it?
Thanks
Last edited by zhshqzyc; 02-10-2011 at 03:16 PM.
This is not the behavior I see when I save tab-delimited files. Do you have actual blank data in the last column? Or is it completely unused? Can you post an example .xlsx file that causes this?
For ex,
in excel becomes1 2 3 4
in the text file.1\t2\t3\t4\t
I understand exactly what you mean. But when I do the same thing I do not get the final tab. I need to see your source file to see why it does this. I suspect there is blank data in column E.
Last edited by 6StringJazzer; 02-10-2011 at 05:16 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks