LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
file open details option stopped working Charter School Setting up and Configuration of Excel 3 August 18th 06 09:42 PM
Excel stopped working Waldy Setting up and Configuration of Excel 2 August 3rd 05 02:40 PM
excel 97 stopped working john f Excel Worksheet Functions 1 April 13th 05 11:52 PM
text to speech stopped working in excel helpmax Excel Discussion (Misc queries) 1 January 27th 05 04:19 AM
excel stopped working Steve Excel Discussion (Misc queries) 0 January 13th 05 04:07 AM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"