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: In actuality, it gets rid of all extra spaces. For example, if the text in cell A1 is: This is a really bad sentence. The Excel function =TRIM (A1) will provide the following result: This is a really bad sentence. 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.