Info

Figure 18.2

Excel guesses at where each field starts.In this case,it missed two fields and probably did not leave enough room for a longer product name.

Figure 18.2

Excel guesses at where each field starts.In this case,it missed two fields and probably did not leave enough room for a longer product name.

To add a new field indicator in Step 2 of the Wizard, simply click in the appropriate place in the Data Preview window. If you click in the wrong column, click on the line and drag it to the right place. If Excel inadvertently put in an extra field line, double-click the line to remove it. Figure 18.3 shows the data preview after the appropriate changes have been made. Note the little ruler above the data. When you click to add a field marker, Excel is actually handling the tedious work of figuring out that the Customer field starts in position 25 for a length of 11.

Figure 18.3

After adding two new field markers and moving the marker between Product and Date to the right place, Excel can build the code that gives us an idea of start position and length of each field.

Figure 18.3

After adding two new field markers and moving the marker between Product and Date to the right place, Excel can build the code that gives us an idea of start position and length of each field.

In Step 3 of the Wizard, Excel always assumes that every field is in General format.

Change the format of any fields that require special handling. Click the column and choose the appropriate format from the Column data format section of the dialog box. Figure 18.4 shows the selections for this file.

0 0

Post a comment