CLEAN
Text

Removes all nonprintable characters from text

Syntax:

=CLEAN(text)

Example:

=CLEAN(A1)