This article describes the formula syntax and usage of the CLEAN function in Microsoft Excel. Description. 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. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.