How do I format a notpad document into Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've downloaded a document from Notepad to Excel. How can I format it to
different columns, or utilize the way it is now and it would print out each
line without cutting off portions of each line?
 
Try Data>Text to Columns to break it out into columns.

Delimited by space or comma ot tab or whatever.

Actually Notepad should generate a *.txt file.

Open that directly in Excel and the Text Wizard should pop up.


Gord Dibben MS Excel MVP
 
Back
Top