notepad to excel

[jeremy via OfficeKB.com]

I have file in notepad and have to change a lot of entries. When i paste
it into excel, the values are in the same column. I think I can only edit
how i want if the values are in separate columns? is there an easy way to
do this?
thanks

jeremy

--
Message posted via http://www.officekb.com

[Barb R.]

Assuming they are delimited well, you can use DATA -> TEXT TO COLUMNS. Come
back if you have more questions.

"jeremy via OfficeKB.com" wrote:

> I have file in notepad and have to change a lot of entries. When i paste
> it into excel, the values are in the same column. I think I can only edit
> how i want if the values are in separate columns? is there an easy way to
> do this?
> thanks
>
> jeremy
>
> --
> Message posted via http://www.officekb.com
>