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:
Excel How to Remove Only Text Or Only Numbers
Remove text or numbers or symbols from cells in Excel You can remove only text…
Excel Extend Selection To Last Used Row
Easily Extend Selection To The Last Used Row Normally if you want to select a…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
How To Sum And Count Cells By Color In Excel
Sum and count and average cells by color in Excel To make the data stand…
How to Select Interval Rows or Columns in Excel
Select Interval Rows Or Columns In Excel Easily select interval rows or columns, for example,…
Excel Clean Data
Clean Data In Excel Clean data in huge Excel sheets could take long time doing…