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: Using the TRIM Function
To remove extra spaces with the TRIM function, follow this procedure: Click on cell A6 to make it the active cell – this is where the function will go. Type =TRIM (A4). Press Enter. The text from A4 with extra spaces will appear in A6, but with all of the extra spaces removed. The problem at this point is that both A4 and A6 exist in the sheet when you only want the clean text (in A6) to replace the messy text (in A4). Replacing the content from A6 to A4 is simple to accomplish: Right-click on A6. Select Copy. Right-click on A4.