you’ve got the option to use CLEAN to strip non-printing characters and strip line breaks from text.
Text without these characters is returned unchanged.
Note that CLEANwillremove line breaks if found.
CLEAN will not remove extra space characters.
To remove extra space, use theTRIM function.
Unicode contains other non-printable characters that are not removed.
Seethis pagefor more information.