CLEAN Function Syntax and Arguments
A function’ssyntaxis its layout and includes the name, brackets, andarguments.
Non-printable Unicode characters includenumbers 129,141,143,144, and157.
Additionally, you may wish to remove127, which is the delete character and is also non-printable.
you’ve got the option to nest theSUBSTITUTEandCLEANfunctions to make it easier.
Alternately, one can simply substitute the offending non-printable character with nothing ("").
What Are Non-Printable Characters?
Each character on a computer printable and non-printable has a number known as itsUnicode character codeor value.
They are used by programs to control peripheral devices such as printers, across different platforms.
As such, they are not intended for use in a worksheet and can cause errors when present.
