Learn How to Use Microsoft Excel CLEAN Function

Microsoft Excel CLEAN Function

The main purpose of the Microsoft Excel CLEAN function is to strip non-printable characters from a text. That means, with the help of the CLEAN function, you can take a text string and returns a text which is cleaned of line breaks and other non-printable characters.

CLEAN Function Return Value

It will return the text without any non-printable characters.

CLEAN Function Syntax

=CLEAN (text)

Where the arguments:

• text: The text which you want to clean.

How to Use Microsoft Excel CLEAN Function?

Well, as we know, we can use the CLEAN function to remove characters that or not printable from a specific text. Besides that, you can also use the CLEAN function to strip line breaks from the text.

It should be noted that the CLEAN function removes the 32 non-printable characters in the 7 bit ASCII code (values between 0 to 31) from the text provided. Unicode also contains non-printable characters which can't be removed. 

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel