LEFT

**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

Grey Trout Software

02 March 2003