Page 105 - Excel Data Analysis

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

WORKING WITH EXTERNAL DATA 5

If you do not want to keep part of the text in If you want to maintain the original column, you can
your worksheet, you can eliminate it during paste the converted text in a separate location. In the
the conversion process by skipping the Destination field in the last page of the Convert Text
corresponding column. You must place the to Columns Wizard, you can specify where to locate
unwanted text in a separate column on the the converted text. If you want to place the text in
second page of the Convert Text to Columns another location, you can type the cell reference in
Wizard. In the final page of the Wizard, you the field or click the Collapse Dialog button and select
must select the column and click the Do not the new location. You only need to specify the first
import column option (skip) ( changes to cell of the new location. When you paste the
). When you click Finish, all the columns converted text in a new location, the original column
marked Skip are ignored. of text remains unchanged in the worksheet.

■ The next page of ■ You can click a line and ■ The final page of the ■ You can click Advanced to
the wizard displays with drag it to a new location. Wizard displays. define numeric separators for
break lines separating your your data.
data based on what you have Á Click Next. ■ To specify a column
in the cell. format, click a column and ‡ Click Finish.
click the appropriate data
ˇ Click the Data preview format. ■ Excel breaks the specified
window to insert a column column into multiple
break line. columns. 91