next up previous contents index
Next: RMS Up: A. Function Reference Previous: REPLACE, XLREPLACE   Contents   Index


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


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