Sponsored Link
Purpose
Strip non-printable characters from text
Return value
Text with non-printable characters removed.
Syntax
=CLEAN (text)
Arguments
- 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
