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: 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. 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.