CLEAN Function Explained
The CLEAN function in Microsoft Excel removes all non-printable characters from a string of text. It takes a single argument, which is the text string to be cleaned, and returns a text string with all non-printable characters removed. Non-printable characters are characters that cannot be seen when the text is printed, such as ASCII characters 0 through 31.
CLEAN Function Syntax
CLEAN(text)
- text: The text string that you want to clean. This argument can contain characters that are not printable, such as carriage returns and line feeds.