CLEAN function
The CLEAN function is one of the text and data functions. Is used to remove all the nonprintable characters from the selected string.
Syntax
CLEAN(text)
The CLEAN function has the following argument:
| Argument | Description |
|---|---|
| text | A string with nonprintable characters you need to remove, data included into the cell you make reference to. |
Notes
How to apply the CLEAN function.
Examples
The figure below displays the result returned by the CLEAN function.
