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
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy