Importing data

Resolved · Low Priority · Version 2003

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

Chris has attended:
Excel Advanced course

Importing data

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

Wed 30 Jul 2008, 11:14 Trainer 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 tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips

Importing data

Importing data

RE: Importing data

Excel articles

Excel tip:

Use the Format Painter to copy formatting more than once in Excel