Page 102 - Excel Data Analysis

06 537547 Ch05.qxd 3/4/03 12:11 PM Page 88

EXCEL DATA ANALYSIS

IMPORT A DELIMITED TEXT FILE (CONTINUED)

n the second page of the Text Import Wizard, you wizard. With this option, you manually insert breaks. See
can tell Excel how to divide the text into columns. the section "Divide a Column into Multiple Columns" for
OThe options that display on the second page vary more information on this option.
depending upon whether you selected the Delimited or
Fixed width option. The final page of the Text Import Wizard shows how Excel
will import the text file. By default, Excel applies the
If you select the Delimited text option, the second page of General data format to the entire text file. You can define
the wizard requests the delimiter characters that represent what data format you want Excel to apply to each column.
column breaks in the text file. You can select multiple If a column contains a specific type of value, you can select
column delimiters. For example, if you select Tab and the column, and then select the desired data format. For
Comma, Excel inserts a column break at the location of example, if one column contains date values, you can select
every comma and tab character in the text. As you select the Date option, and then specify the format of the dates in
options, the Data Preview window moves the text into the column.
columns to illustrate how Excel will import the text file.
Finally, Excel takes you to the Import Data dialog box,
If you want to split the text at an exact location, for where you must select where you want to import the
example, exactly at the fifth character, you have the option contents of the text file. You can either import the text file
of selecting the Fixed width option on the first page of the into the current worksheet or create a new worksheet.

IMPORT A DELIMITED TEXT FILE (CONTINUED)

■ Excel displays the next ■ You can click multiple ■ The final page of the Text ± Click Finish.
page of the Text Import delimiter options. Import Wizard displays.
Wizard.
■ The Data Preview window — To specify a column
· Click the appropriate shows the effect of your format, click the column, and
delimiter options for the text selections. then click the appropriate data
file. format.
‚ Click Next.
88