CLEAN

Name

Clean

Description

Removes all non-printable characters from text.

Syntax

CLEAN(text)

Remarks

The text argument is any data from which you want to remove non-printable characters.

Use the CLEAN function to remove text that contains characters that might not print with your operating system. For example, you can use the CLEAN function to remove some low-level computer code, which is frequently at the beginning and end of data files and cannot be printed.

See also TRIM.

Data Type

Accepts string data. Returns string data. For more information, see Data Type for Each Cell Type.

Example

In this example, Chr(7) returns a non-printable character.

fpSpread1.Formula = "CLEAN(""" + Chr(7) + "text" + Chr(7) + """)" equals "text"