How to remove leading spaces in excel


Staff member
Whenever you want to remove blank spaces in your Excel sheets, perform these 4 quick steps:
  1. Select the cells (range, entire column or row) where you want to delete extra spaces.
  2. Click the Trim Spaces button on the Ablebits Data tab.
  3. Choose one or several options: Remove leading and trailing spaces. ...
  4. Click the Trim button.