Microsoft Office Tutorials and References
In Depth Information
Importing a Text File into a Worksheet Range
Importing a Text File into a Worksheet Range
If you need to insert a text file into a specific range in a worksheet, you might think that your only
choice is to import the text into a new workbook (by choosing Office
Open) and then to copy
the data and paste it to the range where you want it to appear. However, you can do it in a more
direct way.
Figure 175-1 shows a small CSV ( comma separated value) file. The following instructions describe
how to import this file beginning at cell C4.
Figure 175-1: This CSV file will be imported into a range.
1. Choose Data
Get External Data
From Text to display the Import Text File dialog box.
2. Navigate to the folder that contains the text file.
3. Select the file from the list and then click the Import button to display the Text Import
4. Use the Text Import Wizard to specify how the data will be imported.
For a CSV file, specify Delimited, with a Comma Delimiter.
5. Click the Finish button.
Excel displays the Import Data dialog box.
6. In the Import Data dialog box, click the Properties button to display the External Data
Range Properties dialog box.
Search JabSto ::

Custom Search