notepad to excel

  • Thread starter jeremy via OfficeKB.com
  • Start date
J

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
 
B

Barb R.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
Excel And Notepad 3
Autonumber field in Excel that behaves the same as Access 0
Embed the same Excel multiple times 0
Excel does not accept text format! 0
Importing from a Notepad file 3
Merging from an Excel file with graphics 1
Format column widths from one table to a separate table on same page 1

Top