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