Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > Text > TRIM
 

TRIM(text)

 
 The text string with all spaces removed from the beginning and end.

 textThe text from which you want spaces removed.

 REMARKS
 
  		• Extra spaces can prevent your formulas from working correctly.
     
  		• The only spaces left will be a single space between words.
     
  		• If words have more than one space between them, they are replaced with a single space.

     EXAMPLES
     
     A
    1=TRIM(" Better Solutions ") = Better Solutions
    2=TRIM(" double space ") = double space
    3=TRIM(" triple space ") = triple space
    4=TRIM(" right") = right
    5=TRIM(" left") = left
    6=TRIM(" left right ") = left right
    7=TRIM(" Microsoft Office Development ") = Microsoft Office Development
    		 
     Functions - T | Index - T | Text Manipulation | Office Online 2013 | 2010 | 2007 | 2003 
     © Better Solutions Limited 04-Jun-2013Top