Title: Removing Spaces in Excel 2010 Made Easy
Headings: 

Content: 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. In such cases, you will have to use the formula
=TRIM (SUBSTITUTE (Cell Reference,CHAR (160),CHAR (32)))
Remove Spaces In Excel Between Words Using Find and Replace Functionality
If you need to remove extra spaces between words you can make use of the Find and Replace functionality. This will also remove leading and trailing spaces by one space but won’t completely remove them. 1. Select the range of cells where you want to remove the extra spaces. 2.