To use this function, choose Calc > Calculator.

Removes all nonprintable characters. Nonprintable characters may be embedded in text when you import text from external sources.

Syntax

CLEAN(text)

For text, specify the text column to clean.

Example

Column Calculator expression Result
C1 contains high CLEAN(C1) high