I have the Excel 2000 (9.0.8960 SP3). I created a speadsheet with 4 worksheets in it. I save each of these works sheets as separate Tab delimited Text files. I see extra tabs stored in the tab delimited text files. This happens if I have uneven number of columns of data in the file.
For example , if my data file is as follows with the following data in each of the cells on the row numbers specified

Row 1: Comment line
Row 2: Data1
Row 3:
Row 4: <Heading1> <Heading2> <Heading3>
Row 5: Data0 Data1 Data2

My text file looks as follows with the number of tab as specified by <Tab>
-------------------------------------------------------------------------
comment line <Tab><Tab><Tab>
data<Tab><Tab><Tab>

<heading1><Tab><heading2><Tab><heading3><Tab><heading4>
data0<Tab>data1<Tab><Tab>
data0<Tab>data1<Tab>data2<Tab>data3
--------------------------------------------------------------------------
I have a program that parses this text file and splits data with the tab delimiter. So, when the program see extra tabs, it thinks there are more data points with null data and adds them. I need to have the file as follows for proper export of this data file.
-------------------------------------------------------------------------
comment line
data

<heading1><Tab><heading2><Tab><heading3><Tab><heading4>
data0<Tab>data1<Tab><Tab>
data0<Tab>data1<Tab>data2<Tab>data3
--------------------------------------------------------------------------

Please let me know how I can prevent excel from putting in these extra tabs.

Appreciate any help.