CLEAN removes any control ASCII characters from the input argument.
Function category: Text
String to be cleaned.
Control (or non-printable) characters are not normally printed, so when using the
CLEAN function visible differences will not likely be seen. To test the
CLEAN function, control characters can be inserted into a string using the
CHAR function as follows:
CLEAN("TEST" + CHAR(13))
This returns the following string without the carriage return character: