Excel CLEAN Function

Excel CLEAN Function

Sponsored Link


Strip non-printable characters from text

Return value 

Text with non-printable characters removed.


=CLEAN (text)


  • text – The text to clean.

Usage notes 

You can use CLEAN to remove characters that are not printable from text. You can also use CLEAN to strip line breaks from text.

Note: The CLEAN function removes the first 32 (non-printable) characters in the 7-bit ASCII code (values 0 through 31) from text. Unicode contains other non-printable characters that are not removed. Microsoft has an article that provides more detail here:https://support.office.com/en-us/article/Remove-spaces-and-nonprinting-characters-from-text-023f3a08-3d56-49e4-bf0c-fe5303222c9d

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas