Apple numbers User Manual

    Dictionary of Functions 

 

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.

  

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.

  

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.

  

LEFT("one two three", 2) returns "on".

LEFT("abc") returns "a".

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.

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.