Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 65

The wizard has automatically determined that the wheat.txt fi le is orga-

nized as a fi xed-width text fi le. By moving the horizontal and vertical scroll

bars, you can see the whole data set. Once you’ve started the Text Import

Wizard, you can defi ne where various data columns begin and end. You can

also have the wizard skip entire columns.

To defi ne the columns you intend to import:

1 Click the Next button.

The wizard has already placed borders between the various columns

in the text fi le. You can remove a border by double-clicking it, you

can add a border by clicking a blank space in the Data Preview win-

dow, or you can move a border by dragging it to a new location. Try

moving a border now.

2 Click and drag the right border for TotalOZ further to the right so

that it aligns with the left edge of the ServingGrams column. See

Figure 2-23.

Figure 2-22
Text Import
Wizard
Step 1 of 3