Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent a text to columns while opening a csv file in Excel
By the way.
There is a way to succesfully import the file into excel. That is opening the file in notepad and pasting it into excel. But that is a way I'd rather prefer to NOT do. M. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent a text to columns while opening a csv file in Excel
If this is something you'll be doing regularly, you can set it up as an import, rather than
a File - Open. You'll specify how you want it imported, and when you refresh the data range, it will remember how you want it imported. Data - Import External Data - Import data. Change the file type to yours (txt, csv, whatever), navigate to the folder and select the file. Follow the import prompts. Now your worksheet is a Data Range. Next time you want to read the file, right-click in it, and Refresh. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Michiel via OfficeKB.com" <u40062@uwe wrote in message news:87b0dd3533aa2@uwe... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I prevent a text to columns while opening a csv file in Excel
Thanks Earl,
Yest I use import now as a workaround. The problem is I need to open several files from different locations and different layout. Right cliock and open with is in that case the fasted way. M. Earl Kiosterud wrote: If this is something you'll be doing regularly, you can set it up as an import, rather than -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save excel file in text format without columns? | Excel Discussion (Misc queries) | |||
How do I prevent excel from opening with a blank worksheet? | Excel Discussion (Misc queries) | |||
opening text file in excel problem | Excel Discussion (Misc queries) | |||
Opening a text file | Excel Discussion (Misc queries) | |||
Opening a text file in excel | Excel Discussion (Misc queries) |