Converting excel 2007 to tab delimeter text file

N

Naresh kumar

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.
 
S

Sheeloo

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?
 

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

Converting URLs in comments to Markdown-formatted links 2
Save Excel file to CSV with quotation mark data delimeter? 2
Excel 2007 convert into tab delimeter text file with extra tab spa 0
Converting excel to PDF, single page converts to multiple HELP! 1
Merging from an Excel file with graphics 1
Excel data import of tab-delimited text sees capital 'F' as delimi 0
Word macro that can call cells out of Excel for a find and replace 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top