Showing posts with label TRIM Function in Excel. Show all posts
Showing posts with label TRIM Function in Excel. Show all posts

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: