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: Double-click the right mouse button to auto-fill the entire column
Now you'll have column A with the extra spaces, and column B with the same text cleaned up. Perform the same copy and paste (values only) procedure in the previous step, but copy and paste the entire columns rather than just individual cells. Finally, right click at the top of column B to highlight the entire column, and delete it, shifting all other cells on the spreadsheet to the left. Using the Search and Replace Short Cut Key
If the text in your column has extra spaces within the text, not right before or right after, you can quickly clean that text by using Excel's Search and Replace feature. Select the entire column you want to clean. 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.