Navigation:  Formula Reference > Spreadsheet Formula Functions >

CLEAN

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

SUBSTITUTE

TRIM