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 Extend Selection To Last Used Row
Easily Extend Selection To The Last Used Row Normally if you want to select a…
Excel Sort Sheets
Sort Sheets by alphanumeric or date In Excel Sort your sheets in your current workbook…
Excel Reading Layout View
Excel Reading Layout If you have a lot of data at your Excel sheet, then…
Excel How to Remove Only Text Or Only Numbers
Remove text or numbers or symbols from cells in Excel You can remove only text…
Reverse Text in Excel: Flip Words & Characters Without Formulas
Excel, a powerhouse for data manipulation, often presents unique challenges when dealing with text. One…
Excel Navigation
Navigation to Excel Sheets If you have many opened workbooks and want to navigate to…