Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Turning a notepad document into an excel spreadsheet
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I mirror pages in an excel document for printing? | Excel Discussion (Misc queries) | |||
Scan and edit document in excel 2003. | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) | |||
excel cannot open .xls the document may be read only or encrypted | Excel Discussion (Misc queries) |