Title: How to remove leading and trailing spaces in Excel ?
Headings: How to remove leading and trailing spaces in Excel?
How to remove leading and trailing spaces in Excel?
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Using Trim function in Excel to remove leading and trailing spaces
Quickly remove all leading and trailing spaces with Kutools for Excel
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Content: Supports all languages; Easy deploying in your enterprise or organization. Read More... Free Download...
Using Trim function in Excel to remove leading and trailing spaces
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day! The syntax for the TRIM function is: = TRIM ( Text )
Like the following example shows, to remove the space in the cell C11, just click a new cell and enter the trim formula to apply the modification. See screenshot: Note: The TRIM function will not remove all space characters.