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

Use

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

Syntax

= 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.

Example

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

2. Result.

 

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