View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Art Saffran Art Saffran is offline
external usenet poster
 
Posts: 2
Default Drag text file to Excel -- stopped working

For several months I have been importing a space delimited text file to Excel
by simply dragging the .txt file to an open Excel worksheet. The text file is
then parsed into columns automatically. It's a very quick alternative to
importing the txt file.

Today, after a Windows update was automatically installed, the txt file is
no longer parsed. Rather, it brings in the data rows as a single column
instead of separate columns. Since I need to copy one column, this is a
problem.

Is there a way to restore the ability of Excel to parse the data
automatically when the delimited text file is dragged to an open Excel
worksheet?

Thanks.

--Art