next up previous contents index
Next: LENGTH, LEN Up: A. Function Reference Previous: LARGE   Contents   Index


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


next up previous contents index
Next: LENGTH, LEN Up: A. Function Reference Previous: LARGE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003