next up previous contents index
Next: TRUE Up: A. Function Reference Previous: TREND   Contents   Index


TRIM

Syntax: TRIM(S)

S = a string value

TRIM returns the string formed by removing leading, trailing and consecutive embedded spaces from string S.

Examples:

TRIM(``   Alpha    Beta   Gamma   '') = ``Alpha Beta Gamma''

TRIM(R5) = ``There's no place like home.'', where R5 = ``There's no place like home.''

Excel function: TRIM


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