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: Learn How to Remove Extra Spaces From Excel Using TRIM
Software & Apps MS Office
How to Remove Extra Spaces From Excel
An easier way to clean up your Excel spreadsheet
by
Ted French
Writer
Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process
Ted French
Updated on October 13, 2019
Tweet
Share
Email
MS Office
Excel
Word
Powerpoint
Outlook
When you import or copy text data into an Excel worksheet , you often end up with extra spaces. Using Excel's TRIM function, or a shortcut key to trigger Excel's search and replace feature, you can easily remove those unnecessary spacing. In the case of the TRIM function, you'll need to create a new column in the worksheet for your clean text. Then you can copy and paste the clean text back into the original column. A much faster trick is to use the CTRL + H shortcut key to search the problem column and quickly remove all of the extra spaces. How the TRIM Function Works
The syntax for the TRIM function is: =TRIM (Text)
The Text, in this case, refers to the data with the extraneous spacing. This argument can be: The actual text enclosed in quotation marks
A cell reference to the location of the text data in the worksheet
Many people think that the TRIM function removes only the spaces at the beginning and the end of the text.