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:
How to Change Text Case In Excel
Change Case Of Excel Cells Text Change case of text in selected cells in Excel…
Excel Count Chars
Count Chars In Excel Count chars in a cell or in a selected range of…
Excel Export Sheets
Export Sheets Separately In Different Formats In Excel Exporting from sheets from Excel using Excel…
Excel Compare Sheets – Advanced Excel Sheet Comparison Tool
Why Compare Excel Sheets? When working with finance reports, inventory audits, or versioned data sets,…
Excel Select Specific Cells
Select Specific Cells In Excel Sheet If you ever want to select some specific cells…
Excel Work Area View
Excel Work Area If you have many data in Excel sheet cells, and want to…
