Spread Formula Reference
CLEAN
Formula Functions > Functions A to C > CLEAN

This function removes all non-printable characters from text.

Syntax

CLEAN(text)

Arguments

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

Remarks

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

Data Types

Accepts string data. Returns string data.

Example

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

CLEAN(CHAR(7)&"text"&CHAR(7)) gives the result text

Version Available

This function is available in product version 1.0 or later.

See Also

TRIM | SUBSTITUTE | Text Functions