Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Importing data
Resolved · Low Priority · Version 2003
Chris has attended:
Excel Advanced course
Can I import a non-tabbed, non-comma seperated wordpad / notepad document into Excel?
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 ExcelThe format painter tool provides a quick and easy way to copy formatting from one cell to another in Word. |
We'll call during UK business hours
Server loaded in 0.07 secs.