Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lbierer
 
Posts: n/a
Default 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   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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I mirror pages in an excel document for printing? mirroring Excel Discussion (Misc queries) 4 March 29th 05 11:55 PM
Scan and edit document in excel 2003. johmoc Excel Discussion (Misc queries) 0 March 18th 05 04:53 PM
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM
Copying an Excel spreadsheet to a Word document KG Excel Discussion (Misc queries) 1 November 28th 04 07:38 PM
excel cannot open .xls the document may be read only or encrypted mukesh Excel Discussion (Misc queries) 0 November 27th 04 12:35 PM


All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"