LEFT(s,num_chars)
s: the string
num_chars: the number of characters to return (defaults to 1)
If the string s is in a right-to-left script, the returned first characters are from the right of the string.
This function is Excel compatible.
This function is OpenFormula compatible.