How to Remove Unwanted Characters in 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.