close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()