Import text file - Did something break - delimiter

  • Thread starter Thread starter Ron H
  • Start date Start date
R

Ron H

I have been able to click on a tab delimited text file and presto, it was
correctly imported to a worksheet, after a recent "upgrade" it only works
about half the time. I tried setting the global delimiter but it still
misses some but not all of the tabs. If I manually import the file and
select tab as the delimiter, it works fine...

Ron H.
 
Ron,

Try importing your file again, after having manually set the delimiter to tab. It has a way
of remembering the last import. No one knows just why it does that.

I'm guessing you're actually opening the file (File - Open), not truly importing it. If
you'll be importing the file regularly, consider a true import (Data - Import External
Data - Import Data). That will import it into a sheet in an existing workbook, and it will
remember your import specs -- you need only refresh it to read the file again. More at
http://www.smokeylake.com/excel/textfiles.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top