Select the cells from which you want to remove the spaces.
Press Ctrl+H to activate the Replace dialog.
Click in the 'find what' box and type a single space.
Leave the 'Replace with' box empty.
Click the 'Replace All' button.
Excel will tell you how many spaces were replaced.
Click OK, then close the Replace dialog.
Result:
