Text Formulas – Clean Function
[ResponsiveRect]
What Does It Do – Clean Function?
This function removes any nonprintable characters from text.
These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes.
Syntax
=CLEAN(TextToBeCleaned)
Formatting
No special formatting is needed. The result will show as normal text.
Advanced Excel Formulas Index