Apple Numbers '08 - Manual (Page 244)

244 Chapter 12 Dictionary of Functions
LEFT
The LEFT function retrieves the specified number of characters from the left end of a
string.
LEFT(text, [length])
 text: A text expression.
 length: Optional; the number of characters to retrieve. If omitted, the leftmost
character is retrieved.
LEN
The LEN function counts the number of characters in a string. The count includes all
spaces, numbers, and special characters.
LEN(text)
 text: A text expression.
LN
The LN function calculates the natural logarithm of a number, the power to which e
must be raised to produce the number.
LN(number)
 number: A positive number, a numeric expression, or a reference to a cell containing
a positive numeric expression.
Examples
LEFT("one two three", 2) returns "on".
LEFT("abc") returns "a".
Examples
LEN("12345") returns 5.
LEN(" abc def ") returns 15, the sum of the six letters plus the three leading, three trailing, and
three separating spaces.
Examples
LN(2.71828) returns approximately 1, the power to which e must be raised to produce 2.71828.
LN(EXP(1)) returns 1. LN is the inverse of the EXP function.