View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Finn Finn is offline
external usenet poster
 
Posts: 6
Default 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