View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.

lbierer wrote:

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?


--

Dave Peterson