CLEAN

See also A-Z Spreadsheet Function List

Description Removes all non-printable characters from the supplied text.

Syntax CLEAN(text)

text is any spreadsheet information.

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

See Also CHAR and TRIM functions

Example CLEAN(“Payments “ & CHAR(8) & “Due”) returns Payments Due because the character returned by CHAR(8) is non-printable.