To use this function, choose .
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 |
