formatting issue?

[chip_pyp]

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.

[Anne Troy]

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

"chip_pyp" <[email protected]> wrote in message
news:[email protected]...
>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.

[dlw]

do a File/Open / change "files of type" to text, and pick fixed width

"chip_pyp" wrote:

> 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.

[chip_pyp]

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

"Anne Troy" wrote:

> Try opening the file from Excel instead. The import text wizard should kick
> in.
> ************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
>
> "chip_pyp" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>
>

[Anne Troy]

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

"chip_pyp" <[email protected]> wrote in message
news:[email protected]...
> Thank you...this worked wonderfully for what i was trying to do
>
> "Anne Troy" wrote:
>
>> Try opening the file from Excel instead. The import text wizard should
>> kick
>> in.
>> ************
>> Hope it helps!
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "chip_pyp" <[email protected]> wrote in message
>> news:[email protected]...
>> >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.
>>
>>
>>