CLEAN function: Description, Usage, Syntax, Examples and Explanation
What is CLEAN function in Excel? CLEAN function is one of TEXT functions in Microsoft Excel that removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that …