Here's how to use the Clean feature in Microsoft Excel 2019, 2016, 2013, 2010, and Excel for Microsoft 365. The Clean feature removes many nonprinting computer characters that have been copied or imported into a worksheet, because such characters can interfere with printing, sorting, and filtering data.
How to use the CLEAN function in Excel
The syntax of a function is its layout and includes its name, parentheses, and arguments. The syntax for the CLEAN function is:
to the location of this data in the worksheet you want to clean.
For example, suppose cell A2 contains this formula:
