Title: 
Headings: 

Content: How to use the Excel TRIM function to Remove extra spaces from text. The Excel TRIM function strips extra spaces from text, leaving only a single space between words and no space characters at the start or end of the text. How to use the Excel TRIM function | Exceljet
Skip to main content
Login
Cart
Exceljet
Quick, clean, and to the point
Training
Videos
Functions
Formulas
Shortcuts
Blog
Excel TRIM Function
Summary 
The Excel TRIM function strips extra spaces from text, leaving only a single space between words and no space characters at the start or end of the text. Purpose 
Remove extra spaces from text
Return value 
Text with extra spaces removed. Syntax 
=TRIM (text)
Arguments 
text- The text from which to remove extra space. Version 
Excel 2003
Usage notes 
TRIM strips extra spaces from text, leaving only single spaces between words and no space characters at the start or end of the text. TRIM is useful when cleaning up text that has come from other applications or environments. TRIM only removes the ASCII space character (32) from text. Unicode text often contains a non-breaking space character (160) that appears in web pages as an HTML entity. This will not be removed with TRIM.