Info

Toil Import WiHid -Stop Zof 3 [TllxJ

Figure 18.7

While you import a delimited text file, the initial data preview looks like a confusing mess of data because Excel is looking for tab characters between each field.

Toil Import WiHid -Stop Zof 3 [TllxJ

Figure 18.7

While you import a delimited text file, the initial data preview looks like a confusing mess of data because Excel is looking for tab characters between each field.

After unchecking the Tab box and checking the proper delimiter choice (in this case, a comma), the data preview in step 2 looks perfect, as shown in Figure 18.8.

Figure 18.8

After changing the delimiter field from a tab to a comma, the Data Preview looks perfect. This is certainly easier than the cumbersome process in Step 2 for a fixed-width file.

Text Import Wizard

Step 2 of

0 0

Post a comment