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: 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. Select Paste Special. Select Values and then click OK. Delete the text from A6. Now only the clean text, without spaces, exists on the sheet. If you're using Excel Online, disregard steps 4 and 5 above.