Title: Excel Remove Trailing Spaces and Leading Spaces
Headings: How to Remove Leading and Trailing Spaces in Excel
How to Remove Leading and Trailing Spaces in Excel
So, it is extremely important to Excel remove trailing spaces!
TRIM Function to Remove Extra Spaces
=TRIM (
=TRIM (B7)
Substitute Function to Remove Non-Breaking Spaces
=SUBSTITUTE (
=SUBSTITUTE (C9
=SUBSTITUTE (C9,CHAR (160),
=SUBSTITUTE (C9,CHAR (160),” “)
=TRIM (SUBSTITUTE (C9, CHAR (160), ” “))
Find & Replace to remove all spaces
Conclusion
Excellent
Doing a lesson a day or more is a great…
Excellent course that are easy to flow…
An excellent website
Everything that begins well ends well.
Highly recommend
Very clear instruction video’s
My Wonderful Excel Learning Experience
This course is so easy to follow along!
Cool few minutes approach
It has been over a decade since I've had an Excel refresher, Much Needed !!
Best decision since my marriage! :)
Very Effective Training
well presented
Good teaching and it's very visual
My Excel Online Academy Beginner Course
If you like this Excel tip, please share it
email
Pinterest
Facebook
Twitter
Linkedin
About The Author

Content: Enter the TRIM formula in cell C7. =TRIM (
STEP 2: Enter the argument required for this formula – text from which you want extra spaces to be removed. =TRIM (B7)
The spaces get removed with no issues: STEP 3: Now, copy-paste the formula below to the cell range C7: C10. That’s it! All the unwanted spaces are gone. It is quite easy to Excel remove trailing spaces and leading spaces using the Trim function.