Explainry Tutorials to Expert in IT

CLEAN function in Excel: Use, Syntax and Example – Explainry.com


CLEAN function is used to remove non-printable characters, which may appear when you import text from other applications.


= CLEAN(text)

text (argument) means that any information in a worksheet from which you want to clean from non-printable characters.

TRIM vs CLEAN function

Although both functions used to remove extra characters, however, there is a little difference as CLEAN function removes non-printable characters whereas TRIM function eliminates duplicate spaces.


1. Type +CLEAN(address of a cell to clean non-printable characters)

2. Result.


Copyright © 2016 - 2020 Explainry.com | All Rights Reserved