How to remove unwanted characters in Ms Excel

The TRIM function returns a string with extra spaces, starting spaces and ending spaces removed. The CLEAN function removes nonprintable characters from a string.
1. For example, cell A1 below contains the string " Excel   Easy  "



Note: the TRIM function returns the string "Excel Easy".
2. For example, cell A1 below contains a nonprintable character.

Note: the CLEAN function removes this nonprintable character. Text imported from other applications may contain nonprintable characters.