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: 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. In particular one commonly used space character that TRIM will not remove is the non-breaking space used in web pages. Quickly remove all leading and trailing spaces with Kutools for Excel
The third party add-in Kutools for Excel can help remove all the leading and trailing spaces quickly in Excel. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now
Compare with the trim function in Excel, the Removing Spaces utility in Kutools for Excel provides more flexible way to remove all the excessive space in Excel.