This post will guide you how to use Excel CLEAN function with syntax and examples in Microsoft excel.

Description

The Excel CLEAN function removes all non-printable characters from a text string.

The CLEAN function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The CLEAN function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

The syntax of the CLEAN function is as below:

= CLEAN  (text)

Where the CLEAN function argument is:
Text – this is a required argument. The text strings that you want to remove all nonprintable characters

Example:

The below examples will show you how to use Excel Clean Text function to clean all non-printable characters, such as:

#1 To remove all vertical tab characters from text string in B4-B6 cells, just using CLEAN(B4), CLEAN(B5), CLEAN(B6) formulas.

You will get the same results after removing non-printable characters.