Title: Learn How to Remove Extra Spaces From Excel Using TRIM
Headings: How to Remove Extra Spaces From Excel
How to Remove Extra Spaces From Excel
An easier way to clean up your Excel spreadsheet
How the TRIM Function Works
Using the TRIM Function
Removing Extra Spaces From an Entire Column
Using the Search and Replace Short Cut Key
Was this page helpful?

Content: Press the CTRL + H shortcut to open Excel's Search and Replace window. In the Find what field, type two spaces. In the Replace with field, type one space. Keep pressing the Replace All button until all extra spaces are gone. The benefit of using this approach is that you don't have to go through the entire copy-and-paste procedure that you need to with the TRIM function. The method you use to remove extra spaces in Excel depends on what your original data looks like, and where the spaces are. Either way, one of these two methods should work well to help you clean up that messy text in your spreadsheet. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day
Email Address
Sign up
There was an error.