Title: Remove Spaces in Excel - Leading, Trailing and Double
Headings: Remove Extra Spaces in Excel (Leading, Trailing, Double Spaces)
Remove Extra Spaces in Excel (Leading, Trailing, Double Spaces)
FREE EXCEL TIPS EBOOK - Click here to get your copy
Watch Video – Remove Spaces in Excel
This Tutorial Covers:
How to Remove Spaces in Excel
Using the TRIM Function
Remove Extra Spaces in Excel using FIND and REPLACE
Removing Double Spaces
Removing Single Spaces
Remove Line Breaks
You may also like the following Excel tutorials:
FREE EXCEL BOOK
Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Content: Excel TRIM function does a good job in removing spaces in Excel, however, it fails when you have non-printing characters (such as line breaks) in your data set. To remove non-printing characters, you can use a combination of TRIM and CLEAN functions. If you have some text in cell A1 from which you want to remove spaces, use the below formula: =TRIM (CLEAN (A1))
Non-printing characters can also result from =CHAR (160), which can not be removed by the CLEAN formula. So, if you want to be absolutely sure that you have all the extra spaces and non-printing characters, use the below formula: =TRIM (CLEAN ( SUBSTITUTE (A1,CHAR (160)," ")))
Remove Extra Spaces in Excel using FIND and REPLACE
You can remove spaces in Excel using the Find and Replace functionality. This is a faster technique and can be useful in the given situations: When you want to remove double spaces. When you want to remove all the space characters. Removing Double Spaces
Note that this technique cannot be used to remove leading or trailing spaces.