Excel Function : CLEAN

Download now!

Excel Function : CLEAN

Category

Text

Description

Removes all nonprintable characters from text

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CLEAN-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41

Syntax and Description of the CLEAN Excel Function

syntax This is the syntax of the Excel CLEAN function: =CLEAN(text) Where text is the text string that you want to clean. The CLEAN function will remove all non-printable characters from the text string.

About CLEAN Excel Function

CLEAN(text) The CLEAN function removes all non-printable characters from a string. Non-printable characters are typically not visible when viewing a text string in a worksheet.