Syntax: LEFT(S[, N])
S = a string value
N = a numeric value (optional)
LEFT returns the string composed of the leftmost N characters of string S. If N is greater than or equal to the length of S, then the entire string S is returned. If N is omitted, it is assumed to be 1.
Examples:
F1 = ``workstation''
LEFT(F1, 1) = ``w''
LEFT(F1) = ``w''
LEFT(F1, 4) = ``work''
LEFT(F1, 20) = ``workstation''
Excel function: LEFT