Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Importing data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Importing data

Resolved · Low Priority · Version 2003

Reply Wed 23 Jul 2008, 17:38Delegate Chris said...

Chris has attended:
Excel Advanced course

Importing data

Can I import a non-tabbed, non-comma seperated wordpad / notepad document into Excel?

For upcoming training course dates see: Pricing & availability

Reply Wed 30 Jul 2008, 11:14Trainer Pete said...

RE: Importing data

Hi Chris,

Thank you for your post and welcome to the forum: Try This:

Select Data, Get External Data, Import Text File. This command calls up a dialog box in which you select a text file, whereupon the Text Import Wizard lets you specify how Excel should import the data. Finally, in the Import Data dialog box, you indicate the desired worksheet destination. Excel imports the text file as a database query, which you can update if the data in the text file changes (select Data, Refresh Data to do so). To import the file as static data, click Properties in the Import Data dialog, and remove the check mark from the "Save query definition" box.

Hope that helped, regards Pete

Excel articles

· Identifying Suitable Candidates For VBA For Excel Training
· Tips to Facilitate Printing of Excel worksheets
· Break The Mystery Of Code With Excel Macros
· The Key Settings In Excel 2003's Options Panel
· How We Got To The Perfect Spreadsheet: A Brief History

Please browse our web site to find out more about
excel courses and other Microsoft training courses.

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips