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
If you right click on the file that you are opening and select quot;open withquot; 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 quot;text to
columnsquot; feature? If you open it in excel and it has all the data jumbled
together. You highlight column A and select quot;text to columnquot; from there it
will walk you through the delimited tab wizard.
AB
quot;Old Bobquot; wrote:
gt; If I am in an excel spreadsheet and I try to open a .txt file, the test
gt; Import wizard used to open so I could determine columns and data etc. Now,
gt; when I try to open the file, the wizard does not open..excel opens with a new
gt; spreadsheet. How do I get the wizard to open again? My firm re-imaged my
gt; machine and all kinds of things are off.
gt; --
gt; Old Bob
I'll give that a try--thanks
--
Old Bobquot;Amy Bethquot; wrote:
gt; If you right click on the file that you are opening and select quot;open withquot; it
gt; should give the option of excel, from there it should walk you through the
gt; wizard. It is a matter of needing make the .txt file using the quot;text to
gt; columnsquot; feature? If you open it in excel and it has all the data jumbled
gt; together. You highlight column A and select quot;text to columnquot; from there it
gt; will walk you through the delimited tab wizard.
gt;
gt; AB
gt;
gt; quot;Old Bobquot; wrote:
gt;
gt; gt; If I am in an excel spreadsheet and I try to open a .txt file, the test
gt; gt; Import wizard used to open so I could determine columns and data etc. Now,
gt; gt; when I try to open the file, the wizard does not open..excel opens with a new
gt; gt; spreadsheet. How do I get the wizard to open again? My firm re-imaged my
gt; gt; machine and all kinds of things are off.
gt; gt; --
gt; gt; Old Bob
- Dec 25 Tue 2007 20:41
Text Import wizard
close
全站熱搜
留言列表
發表留言