Excel dropping trailing tabs 1

[dodge20]

I have a spreadsheet with column headers through column R. The data may or may not go to column R depending on the row. When I try to save the file as a tab delimited or a .csv it drops all the traling tabs or commas starting on line 17. The previous 16 all have the correct number of tabs. Any ideas what would be causing this?

Dodge20

 

[xlhelp]

Put something in the last cell. Bottom right of the range. CTRL/End will get you to the last cell.

Member- AAAA Association Against Acronym Abusers

 

[dodge20]

I would prefer not to do that, as I am importing this list into a database, and don't want to open the list again to remove the added text. I will do this many times per day, so I would like it to work without having to do that.

Is this a feature in excel? I don't remember this ever happening before.

Dodge20

 

[xlhelp]

If you are importing into a database, then why the need for trailing delimiters? Your db is perchance intelligent enough to know the start of a new record regardless of delimiters.

Member- AAAA Association Against Acronym Abusers

 

[dodge20]

No, the db is very old and not intelligent enough. The columns much match exactly.

Dodge20

 

[xlhelp]

If you scroll down, this may have what you are looking for.

http://www.cpearson.com/excel/imptext.htm

Member- AAAA Association Against Acronym Abusers

 

[dodge20]

Thanks xlhelp

Hopefully microsoft will remedy this feature sometime soon.

Dodge20