Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The CLEAN function is used to tidy up text by removing nonprintable characters. Think of it as a digital cleaner that scrubs away invisible and potentially troublesome characters from your text.
Syntax
CLEAN(text)
The CLEAN function syntax has the following arguments:
- Text Required. Any text from which you want to remove non-printable characters.
Example
| Data |
|---|
| variable = CHAR(9) & "Monthly report" & CHAR(10) |
| Formula | Description | Result |
|---|---|---|
| =CLEAN({variable}) | Removes the non-printable characters CHAR(9) and CHAR(10) from the text string in variable {variable}. | Monthly report |
Errors
For a full list of formula errors, please read Formula errors.