next up previous contents index
Next: CMAX Up: A. Function Reference Previous: CHOOSE, XLCHOOSE   Contents   Index


CLEAN

Syntax: CLEAN(S)

S = a string value

CLEAN returns the string formed by removing all non-printing characters from the string S.

Examples:

CLEAN(A1) = ``test'', where A1=STRCAT(A2, A3), A2=``test'' and A3=CHAR(10)

Excel function: CLEAN


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