notepad to excel
 

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

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