Title: Removing Spaces in Excel 2010 Made Easy
Headings: 

Content: Removing Spaces in Excel 2010 Made Easy
Menu
About
Contact
Privacy Policy
Submit For Review
Template Gallery
Excel 2016 Udemy Course
Skip to primary navigation
Skip to main content
Skip to primary sidebar
TheAppTimes
App Reviews, Tutorials, & Gadget News Hub
Gadgets
How To
Mobile Apps
Software and Web Apps
Buying Guides
Shop
Show Search
Search this website
Hide Search
Home » How To » How to Remove Spaces in Excel 2010 (Leading, Trailing or All)
How to Remove Spaces in Excel 2010 (Leading, Trailing or All)
February 21, 2011
If you are in the habit of copying content from other spreadsheet or from a website to your Excel database, you might often be faced with the situation where the copied content display additional spaces either the beginning or end of a string. You may also find extra spaces within a string. In this Excel 2010 tutorial, you will learn how to remove spaces in excel (leading, trailing, or all ) under different circumstances. How to Remove Spaces in Excel Using TRIM Function (Leading & Trailing Spaces)
1. Place the cursor in the cell where you want the result to appear. 2. Type =TRIM (Cell Reference) and press Enter. The result is that text will now remove all leading and trailing spaces, as well as extra spaces in the middle of a string. There may be times when the TRIM function does not work. For instance, when data is copied from a HTM page, the spaces in the cells are nonbreaking spaces with a decimal character code of 160 rather than a ASCII space decimal character code of 32.