Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft 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(" First Quarter Earnings ") = First Quarter Earnings
    2=TRIM(" right") = right
    3=TRIM(" left") = left
    4=TRIM(" left right ") = left right
    5=TRIM(" words ") = words
     

     Functions - T | Index - T | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top