Excel CLEAN Function

Syntax

=CLEAN(text)

Description

Removes all nonprintable characters from text.
Example Excel File
CLEAN.xlsx · 32.8 KB

Enter your email to receive the example Excel file (link valid 24h).

Become a supporter — download instantly, no email

Related Functions