Remove Unwanted Characters

 

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  "

Trim Function in Excel

Note: the TRIM function returns the string "Excel Easy".

2. For example, cell A1 below contains a nonprintable character.

Clean Function in Excel

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

Do you like this free website? Please follow us on Google+