CLEAN function in Excel
CLEAN removes non-printable characters.
Syntax
=CLEAN(text)
| Argument | Required? | What it is |
|---|---|---|
| text | Required | The text or cell to work with. |
Practise CLEAN in a live spreadsheet
Type the formula yourself and get it graded instantly, no Excel needed.
Related text functions
- LENReturns the number of characters.
- LEFTReturns characters from the start of the text.
- RIGHTReturns characters from the end of the text.
- MIDReturns characters from the middle of the text.
- FINDCase-sensitive position of text within text.
- SEARCHCase-insensitive position of text; supports wildcards.
- CONCATJoins text from cells and ranges.
- CONCATENATEJoins text items (legacy).