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

Content: 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: When you reference a range of cells inside your TRIM function, the results will be grouped (you’ll see a blue outline if you place your cursor in one of the results). This means that they cannot be edited or deleted. Doing so will cause an error for all the results in the group. Unless…
You replace the TRIM function results with only their values (i.e., removing the calculation). To do this: