Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Converting excel 2007 to tab delimeter text file

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 793
Default Converting excel 2007 to tab delimeter text file

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting excel 2003 to 2007 file formats XX23 Excel Discussion (Misc queries) 18 October 27th 09 05:44 PM
Save Excel file to CSV with quotation mark data delimeter? Eric Excel Discussion (Misc queries) 2 December 9th 08 04:05 PM
How to reduce file size when converting to pdf for excel 2007? jk9533 Excel Discussion (Misc queries) 2 August 1st 07 09:35 PM
Converting Excel file to text delimited file Kiran Veeramallu[_2_] Excel Discussion (Misc queries) 3 May 1st 07 07:04 PM
text wrap delimeter armagan Excel Discussion (Misc queries) 2 May 11th 06 04:42 PM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"