- text – The text to clean.
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