Excel adding unwanted tabs to text delimited files
Hi, I am having a problem when I open text delimited files in excel. My data
in my files are separated by tabs, the problem is that I have blank lines
with no tabs which need to remain blank, but excel automatically inserts tabs
on these lines.
This was never a problem with office 2003, xp, 97. I deal with hundreds to
thousands of these files, so having to delete the added tabs after I save the
files in excel is extremely annoying.
Is there any way to fix this?
thanks,
finn
|