Prev: MS Query - Filtering all dates greater than the current date
Next: HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM
From: Naresh kumar Naresh on 26 Mar 2010 19:01 when I convert excel 2007 data into tab delimeter text file, it is adding two extra tab spaces at the end of each row, but it is not happending the same while converting excel 2003 into tab delimeter text file. please suggest me on this.
From: Sheeloo on 27 Mar 2010 11:56
Naresh, I don't think Excel 2007 adds any extra tabs. There might be a value in one of the cells somewhere beyond the columns with your data. Select 4-5 columns to the right of your data and clear them before saving in txt format. Did you test with the same file in both 2007 and 2003? "Naresh kumar" wrote: > when I convert excel 2007 data into tab delimeter text file, it is adding two > extra tab spaces at the end of each row, but it is not happending the same > while converting excel 2003 into tab delimeter text file. please suggest me > on this. |