How to Use CLEAN in Google Sheets in 2020?

CLEANReturns the text with the non-printable ASCII characters removed.
Sample Usage




text – The text whose non-printable characters are to be removed.


This function only removes non-printable ASCII characters. Non-printable Unicode characters that aren’t found in ASCII are not removed.
Google Sheets does not show non-printable characters in the UI, so using this function will typically not result in any visible changes.

See Also

CHAR: Convert a number into a character according to the current Unicode table.

TRIM: Removes leading, trailing, and repeated spaces in text.

SUBSTITUTE: Replaces existing text with new text in a string.