View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michiel via OfficeKB.com Michiel via OfficeKB.com is offline
external usenet poster
 
Posts: 48
Default How do I prevent a text to columns while opening a csv file in Excel

I have read many solutions to the issue that excel sometimes applies the text
to columns feature to text pasted into an Excel worksheet. The solution is to
do a Text To Col and unselect all the options first.

I have the same problem but now while opening a text file from the Windows
Explorer using the "open with Excel" functionality.

The file is indeed opened in excel but Text To Columns (TtC) kicks in with
the TAB selected.
When I unselect the option in TtC and re-open the file in excel. A new
instance of Excel is started that again uses the TtC feature with TAB
selected.

I tried everything after deselecting the options. Closing the file, closing
excel, keeping it open and force a new instance with readonly. But it keeps
TtC-ing....

Anyone anay ideas?

Thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200807/1