In Google Sheets, the CLEAN function is a built-in function used to remove all non-printable characters from a text string.

Non-printable characters include things like line breaks, carriage returns, tabs, and other special characters that cannot be displayed in a visible form.

The syntax for the CLEAN function is as follows:

CLEAN(text)

where text is the string or cell reference containing the text you want to clean.

The CLEAN function returns a new text string with all non-printable characters removed.

It is often used in combination with other functions to clean up imported or copied data that contains unwanted formatting or characters that may cause issues in calculations or further processing.