Text functions – Apple Numbers '08 User Manual
Page 204
204
Chapter 12
Dictionary of Functions
Text Functions
The text functions help you work with strings of characters.
Numbers provides these text functions.
Function
Description
Returns the character that corresponds to a numeric Unicode
character code.
CLEAN (page 213)
Removes most common nonprinting characters (Unicode character
codes 0–31) from text.
Returns the Unicode code number of the first character in a string.
CONCATENATE (page 216)
Concatenates strings.
Converts a number to a string written as a dollar amount with a
specified number of decimal places.
Returns TRUE if the argument strings are identical, including case.
Finds the starting position of one string within another, matching
both character and case but not allowing wildcards.
FIXED (page 232)
Rounds a number to a specified number of places and converts the
result to a string.
Retrieves the specified number of characters from the left end of a
string.
Finds the number of characters in a string.
Converts all uppercase characters in text to lowercase.
Extracts characters from a string starting at a specified position.
Changes the first character in each word of a string to uppercase
and all other characters to lowercase.
REPLACE (page 266)
Replaces part of a string with characters from a second string.
Repeats text a specified number of times.
Retrieves the specified number of characters from the right end of
a string.
Finds the starting position of one string within another, ignoring
case but allowing wildcards.
Replaces part of a string with new text.
Retrieves text from a cell.
Removes spaces from text, leaving only single spaces between
words.
Converts text to uppercase.
VALUE (page 284)
Converts a number formatted as text to a regular number.