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



Usage:
- Select a range of cells.
- Check the option you need to remove leading, trailing, extra or all spaces.
- Then click Apply. You will see the result as shown in the below screenshot.



Demo
More Features:
Excel Clean Data
Clean Data In Excel Clean data in huge Excel sheets could take long time doing…
Excel Delete Blank Sheets
Delete All Empty Worksheets Excel Delete all blank or empty sheets in Excel one time…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…
Excel Filter By Selected Value
Excel Fast Filter To not wasting time by navigating to Data tab and click on…
Excel Change Case
Change Case Of Excel Cells Text Change case of text in selected cells in Excel…
Excel Reverse Text Order
Reverse Text String Order In Excel Reverse any text the way you want, reverse all…