Wednesday, April 20, 2016

TRIM Function in Excel

TRIM function Removes all the unnecessary leading and trailing spaces between words in a string (except single space between the words).

TRIM is useful when cleaning up text that has come from other applications or environments.


Syntax: =TRIM (text)

Parameter list:

    text - The text from which to remove extra space(s).

Example:


 

No comments:

Post a Comment