How to remove extra spaces in excel

admin

Administrator
Staff member
How to remove extra spaces in a cell in Microsoft Excel
  1. Open the Microsoft Excel workbook containing the data you need to edit.
  2. Select the cells that contain extra spaces.
  3. On the keyboard, press Ctrl + H to bring up the Find and Replace tool.
  4. Click in the Find what text field, and press the spacebar once. ...
  5. Leave the Replace with text field empty.
  6. Click Replace All
 
Top