Turning a notepad document into an excel spreadsheet

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

Guest

I am trying to transfer a notepad document into a excel spreadsheet. Is there
a way of doing this without it going into one cell? Can you tell me step by
step how to process this?
 
Save your notepad file as somename.txt.

Then open excel
file|open
point at somename.txt

You'll see a text import wizard open up asking you how your data is laid
out--delimited by some special character or fixed width fields.

You can pick and choose what you need.

But if you've already got that data in column A, you can select column A and
then do Data|Text to columns. You'll see a very similar wizard.
 
Back
Top