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: 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
How to Remove Spaces in Excel
In this tutorial, I will show you two ways to remove spaces in Excel. Using TRIM function. Using Find and Replace. Using the TRIM Function
Excel TRIM function removes the leading and trailing spaces, and double spaces between text strings. For example, in the above example, to remove spaces from the entire list if first names (in A2: A7), use the following formula in cell C1 and drag it down for all the first names: =TRIM (A2)
Excel TRIM function would instantly remove all the leading and trailing spaces in the cell. Once you have the cleaned data, copy it paste it as values in place of the original data. This function is also helpful if you have more than one space character between words. It would remove the extra spaces such that the result always have one space character between words.