Owner manual

The String Operator and the Wildcards
The string operator can be used in formulas and wildcards can be used in conditions.
When you want to Use this string operator or
wildcard
For example
Concatenate strings or the
contents of cells
& “abc”&”def” returns “abcdef”
“abc”&A1 returns “abc2” if cell A1
contains 2.
A1&A2 returns “12” if cell A1
contains 1 and cell A2 contains 2.
Match a single character ? “ea?” will match any string
beginning with “ea” and
containing exactly one
additional character.
Match any number of characters * “*ed” will match a string of any
length ending with “ed”.
Literally match a wildcard
character
~ “~?” will match the question
mark, instead of using the
question mark to match any
single character.
For more information on the use of wildcards in conditions, see “Specifying Conditions
and Using Wildcards” on page 360.
Copying or Moving Formulas and Their Computed Values
Here are techniques for copying and moving cells related to a formula:
To copy the computed value in a formula cell but not the formula, select the cell, m
choose Edit > Copy, select the cell you want to hold the value, and then choose Edit >
Paste Values.
To copy or move a formula cell or a cell that a formula refers to, follow the instructions m
in “Copying and Moving Cells” in Numbers Help or the Numbers User Guide.
In Numbers, if the table is large and you want to move the formula to a cell that’s out
of view, select the cell, choose Edit > “Mark for Move,” select the other cell, and then
choose Edit > Move. For example, if the formula =A1 is in cell D1 and you want to
move the same formula to cell X1, select D1, choose Edit > “Mark for Move,” select X1,
and then choose Edit > Move. The formula =A1 appears in cell X1.
If you copy or move a formula cell: Change cell references as “Distinguishing
Absolute and Relative Cell References” on page 27 describes if needed.
If you move a cell that a formula refers to: The cell reference in the formula is
automatically updated. For example, if a reference to A1 appears in a formula and you
move A1 to D95, the cell reference in the formula becomes D95.
30 Chapter 1 Using Formulas in Tables