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
![How to Remove Leading Or Trailing Or Extra Spaces In Excel](https://zbrainsoft.com/wp-content/uploads/2023/12/1.png)
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.
![Excel Remove Leading Spaces](https://zbrainsoft.com/wp-content/uploads/2023/12/leading-spaces.png)
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.
![Excel Remove Trailing Spaces](https://zbrainsoft.com/wp-content/uploads/2023/12/trailing-spaces.png)
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.
![Excel Remove Extra Spaces](https://zbrainsoft.com/wp-content/uploads/2023/12/extra-spaces.png)
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.
![Excel Remove All Spaces](https://zbrainsoft.com/wp-content/uploads/2023/12/all-spaces.png)
Demo
More Features:
Excel Insert Before After
Insert Text Before Or After In Excel Cells You can add text before first letter…
How To Reverse Text Or Words In Excel
Reverse Text String Order In Excel Reverse any text the way you want, reverse all…
Excel Count Chars
Count Chars In Excel Count chars in a cell or in a selected range of…
How To Insert Checkbox In Excel
Batch Insert Check Boxes In Excel Insert a batch of checkboxes into selected cells without…
Excel Convert Hyperlinks
Extract URL’s From Hyperlinks Or Convert Plain Text Cells Into Hyperlinks In Excel Easily convert…
Excel Merge
How to Merge Cells in Excel Merging cells is a common practice when working with…