Title: 
Headings: 

Content: The excel TRIM functionremoves extra spaces, both in front, in the middle or behind, except for space that separate two words. So the TRIM function can do LEFT TRIM, RIGHT TRIM or “MIDDLE TRIM” simultaneously in one function. TRIM Syntax
TRIM(text)

text, the text from which to remove the extra spaces. Usage Note: The TRIM function removes the extra spaces in all positions, left trim, right trim or middle trim. The TRIM function only removes the extra spaces, to remove non-printing characters use the CLEAN function. How to Use TRIM Function in Excel
For example, there is data as shown below. Column A contains a text; column B calculates the length of the text in column A. Column D is the result of the TRIM function(and the CLEAN function), and column E calculates the text length of the TRIM function result. Excel Left Trim
The Formula 
=TRIM(A2)

Cell A2 has extra space on the left (Excel Left Trim), TRIM function removes all extra spaces and text length in cell D2 becomes 15.