You can remove leading spaces, trailing spaces, extra spaces or all spaces from selected cells in Excel easily with one click without writing any VBA code. Dose for Excel‘s Trim Spaces utility can implement this with one click on huge number of cells.
Click DOSE » Text » Trim Spaces

Remove leading spaces
- Select range of cells, and check Leading (_A) option to remove leading spaces from selected cells and keep the remaining spaces.
- Then click Apply. You will see the result as shown in the below screenshot.

Remove trailing spaces
- Select range of cells, and check Trailing (A_) option to remove trailing spaces from selected cells and keep the remaining spaces.
- Then click Apply. You will see the result as shown in the below screenshot.

Remove extra spaces
- Select range of cells, and check Extra (__A___B____) option to remove extra spaces from selected cells and keep the remaining spaces.
- Then click Apply. You will see the result as shown in the below screenshot.

Remove all spaces
- Select range of cells, and check All option to remove all spaces from selected cells.
- Then click Apply. You will see the result as shown in the below screenshot.

Demo
More Features:
Excel Delete Blank Sheets
Delete All Empty Worksheets Excel Delete all blank or empty sheets in Excel one time…
Excel Delete Columns
Highlight Or Delete Any Type Of Columns Highlight or delete identical, empty, or hidden cell…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…
How To Insert Checkbox In Excel
Batch Insert Check Boxes In Excel Insert a batch of checkboxes into selected cells without…
Excel Insert Empty
Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…
Excel Color Duplicates
Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…