32
178
WordPerfect Office X3 User Guide
For example, you can parse a column of long labels into two or more
columns of data.
When you open a text file that includes tabs indicating new segments
of data, Quattro Pro starts a new column each time it encounters a tab
in the text.
Every sheet in the inserted or imported file that contains data is placed
on a new sheet in the active notebook. If only one sheet is inserted, the
sheet is given the name of the inserted file. If multiple sheets are
inserted, the new sheets are named in the default letter sequence.
You can save notebooks as tab- or comma-delimited text files. You can
also import unformatted text.
You can combine files by adding, subtracting, multiplying, or dividing
the cells of two notebooks. You can also combine files by using math
operators. Adding data is useful for combining files for a cumulative
total. For example, you could compile year-to-date figures from
monthly notebooks to create a cumulative notebook showing year-to-
date expense totals.
For additional information, see “Rules for combining files” in the online
Help.
To insert a file into a notebook
1 Close the file you want to insert.
2 Click Insert ` Insert file.
3 Choose a filename.
If you want to insert a file from another application, include its
filename extension.
4 Type the cell location before which you want to place the inserted
file in the Before sheet box.
If the file is inserted within the boundaries of a named selection
of cells, or cells referenced by a formula, references expand to
include the new spreadsheets.
