CLEAN

Connverts all non-printable characters in an expression to spaces.

Syntax

CLEAN( ext-expression)

Arguments

text-expression

Text or cell reference.

Example

CLEAN(CHAR(7)&"zippy"&CHAR(7)) returns "zippy"

CHAR(7) is a non-printable character.