How to Remove Leading Or Trailing Or Extra Spaces In Excel

Remove Leading Or Trailing Or Extra Spaces From Excel Cells

Excel Change Case

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

Remove leading spaces

  1. Select range of cells, and check Leading (_A) option to remove leading spaces from selected cells and keep the remaining spaces.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Excel Remove Leading Spaces

Remove trailing spaces

  1. Select range of cells, and check Trailing (A_) option to remove trailing spaces from selected cells and keep the remaining spaces.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Excel Remove Trailing Spaces

Remove extra spaces

  1. Select range of cells, and check Extra (__A___B____) option to remove extra spaces from selected cells and keep the remaining spaces.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Excel Remove Extra Spaces

Remove all spaces

  1. Select range of cells, and check All option to remove all spaces from selected cells.
  2. Then click Apply. You will see the result as shown in the below screenshot.
Excel Remove All Spaces

Demo


More Features:

Excel Sort Sheets

Sort Sheets by alphanumeric or date In Excel Sort your sheets in your current workbook…

Excel Count Words

Count Words of Selected Cells In Excel Count words in a cell or in a…

Excel Color Duplicates

Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…

Excel Remove All Macros

Remove All Macros From Excel Workbooks Delete Macros, User Forms, VBA modules, etc. from Excel…


Scroll to Top