FUNCTION CATALOGUE / TEXT
CLEAN Excel function
Removes non-printable characters.
Correct sentence to use
Remove non-printable characters from [text].
Modify this query in PlainFormula →Example formula
=CLEAN(A2)
Removes non-printable characters.
Syntax
CLEAN(text)
Argument signature: text
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.