Remove Leading Or Trailing Or Extra Spaces From Excel Cells
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:
Dose For Excel Settings
Edit Settings of Dose for Excel Using Dose for Excel settings, you can configure what…
How To Convert Numbers To Words In Excel
Convert numbers to words in Excel Converting numerical values into words in Excel holds significant…
Excel Remove By Position
Remove characters by position from text in Excel If you ever want to remove a…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…
Excel Insert Before After
Insert Text Before Or After In Excel Cells You can add text before first letter…
Excel Select Used Range
Select Used Range With One Click Most annoying thing is when you want to select…