Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Import wizard
If I am in an excel spreadsheet and I try to open a .txt file, the test
Import wizard used to open so I could determine columns and data etc. Now, when I try to open the file, the wizard does not open..excel opens with a new spreadsheet. How do I get the wizard to open again? My firm re-imaged my machine and all kinds of things are off. -- Old Bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Import wizard
If you right click on the file that you are opening and select "open with" it
should give the option of excel, from there it should walk you through the wizard. It is a matter of needing make the .txt file using the "text to columns" feature? If you open it in excel and it has all the data jumbled together. You highlight column A and select "text to column" from there it will walk you through the delimited tab wizard. AB "Old Bob" wrote: If I am in an excel spreadsheet and I try to open a .txt file, the test Import wizard used to open so I could determine columns and data etc. Now, when I try to open the file, the wizard does not open..excel opens with a new spreadsheet. How do I get the wizard to open again? My firm re-imaged my machine and all kinds of things are off. -- Old Bob |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Import wizard
I'll give that a try--thanks
-- Old Bob "Amy Beth" wrote: If you right click on the file that you are opening and select "open with" it should give the option of excel, from there it should walk you through the wizard. It is a matter of needing make the .txt file using the "text to columns" feature? If you open it in excel and it has all the data jumbled together. You highlight column A and select "text to column" from there it will walk you through the delimited tab wizard. AB "Old Bob" wrote: If I am in an excel spreadsheet and I try to open a .txt file, the test Import wizard used to open so I could determine columns and data etc. Now, when I try to open the file, the wizard does not open..excel opens with a new spreadsheet. How do I get the wizard to open again? My firm re-imaged my machine and all kinds of things are off. -- Old Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set Default import properties such as Text Qualifier? | Excel Discussion (Misc queries) | |||
programatically selecting columns to import text into | Excel Discussion (Misc queries) | |||
Can you change the settings for an Import Wizard | Setting up and Configuration of Excel | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
Text Import Wizard | Excel Discussion (Misc queries) |