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.



For text, specify the text column to clean.


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