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.

0 comments:

Post a Comment

 
Top