Title: Remove Spaces at the End + Beginning of a Cell in Excel (+ video tutorial)
Headings: 

Content: How to Use the TRIM Function in Excel
What does the TRIM Function do in Excel? TRIM, one of Excel’s Text functions, removes extra spaces from the beginning and end of a cell in Excel. These extra spaces can be the result of formatting changes, mistakes in data entering, or other errors. Why Use the TRIM Function
Having extra spaces in cells can affect how you can use the data in your spreadsheet. Sorting your data, for example, won’t work correctly if your cells have extra spaces in the front. Extra spaces at the end of cells can make it hard to correctly join text from different cells or use other features like Flash Fill. Using TRIM to clean up these spaces will make your spreadsheet easier to use. How to Use TRIM in Excel
Using TRIM in Excel is pretty easy! Find a space in your spreadsheet where you can enter the TRIM function – next to your data is usually the easiest
Type =TRIM (cell to TRIM)
In the parentheses, enter the cell address that you want to trim extra spaces from
Press Enter when done
Example of TRIM Function in Excel
Apply TRIM to Multiple Cells at the Same Time
You can also apply TRIM to a range of cells at once either by: Dragging down your original TRIM function
Using copy and paste to apply it to other cells
Referencing the cell range in your TRIM function or
Assigning a Defined Name to your data range and referencing that name in your TRIM Function
Example of Applying TRIM to Range of Cells
NOTE: