Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting excel 2003 to 2007 file formats | Excel Discussion (Misc queries) | |||
Save Excel file to CSV with quotation mark data delimeter? | Excel Discussion (Misc queries) | |||
How to reduce file size when converting to pdf for excel 2007? | Excel Discussion (Misc queries) | |||
Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
text wrap delimeter | Excel Discussion (Misc queries) |