RIGHT

**Syntax:** **RIGHT( S[, N])**

*S* = a string value

*N* = a numeric value (optional)

**RIGHT** returns the string composed of the rightmost *N*
characters of *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''

**RIGHT**(F1, 1) = ``n''

**RIGHT**(F1) = ``n''

**RIGHT**(F1, 4) = ``tion''

**RIGHT**(F1, 20) = ``workstation''

**Excel function:** RIGHT

Grey Trout Software

02 March 2003