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.