CLEAN


Description Removes all nonprintable characters from the supplied text.

Syntax CLEAN ( text )
Argument Description
text Any worksheet information.

Remarks Text that is imported from another environment may require this function.

Examples This function returns Payments Due because the character returned by CHAR (8) is nonprintable:

CLEAN("Payments " & CHAR(8) & "Due")

See Also CHAR, TRIM