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.
0 comments:
Post a Comment