software

I have a information saved as a text file in notepad....there are three
columns, obviously not formated that way, but spaced evenly. is it possible
to paste it into excel and have it seperated into columns? when i paste it in
there now the text for an entire line goes in one cell. i need it seperated
into 3 cells.

Try opening the file from Excel instead. The import text wizard should kick
in.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;chip_pypquot; gt; wrote in message
...
gt;I have a information saved as a text file in notepad....there are three
gt; columns, obviously not formated that way, but spaced evenly. is it
gt; possible
gt; to paste it into excel and have it seperated into columns? when i paste it
gt; in
gt; there now the text for an entire line goes in one cell. i need it
gt; seperated
gt; into 3 cells.
do a File/Open / change quot;files of typequot; to text, and pick fixed width

quot;chip_pypquot; wrote:

gt; I have a information saved as a text file in notepad....there are three
gt; columns, obviously not formated that way, but spaced evenly. is it possible
gt; to paste it into excel and have it seperated into columns? when i paste it in
gt; there now the text for an entire line goes in one cell. i need it seperated
gt; into 3 cells.

Thank you...this worked wonderfully for what i was trying to do

quot;Anne Troyquot; wrote:

gt; Try opening the file from Excel instead. The import text wizard should kick
gt; in.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;chip_pypquot; gt; wrote in message
gt; ...
gt; gt;I have a information saved as a text file in notepad....there are three
gt; gt; columns, obviously not formated that way, but spaced evenly. is it
gt; gt; possible
gt; gt; to paste it into excel and have it seperated into columns? when i paste it
gt; gt; in
gt; gt; there now the text for an entire line goes in one cell. i need it
gt; gt; seperated
gt; gt; into 3 cells.
gt;
gt;
gt;

Cool beans.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;chip_pypquot; gt; wrote in message
...
gt; Thank you...this worked wonderfully for what i was trying to do
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Try opening the file from Excel instead. The import text wizard should
gt;gt; kick
gt;gt; in.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;chip_pypquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a information saved as a text file in notepad....there are three
gt;gt; gt; columns, obviously not formated that way, but spaced evenly. is it
gt;gt; gt; possible
gt;gt; gt; to paste it into excel and have it seperated into columns? when i paste
gt;gt; gt; it
gt;gt; gt; in
gt;gt; gt; there now the text for an entire line goes in one cell. i need it
gt;gt; gt; seperated
gt;gt; gt; into 3 cells.
gt;gt;
gt;gt;
gt;gt;