CLEAN function

Category: Text
Introduced: Excel 2003

Summary

Removes all nonprintable characters from text

Syntax

CLEAN(text) The CLEAN function syntax has the following arguments:
• Text Required. Any worksheet information from which you want to remove nonprintable characters.

Example

=CHAR(9)&"Monthly report"&CHAR(10)
=CLEAN(A2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41

Back to Functions