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: STEP 1: Select the cell range from which you want to remove spaces. STEP 2: Go to Home > Find & Select > Replace or Press Ctrl + H to open the Find & Replace dialog box. STEP 3: Press the Space bar in the Find what field to insert a space and keep the Replace with field empty. STEP 4: Click the Replace All button and then click OK. All the spaces are now removed! This is how you can Excel remove trailing spaces, trailing spaces, and non-breaking spaces, too!