Yes, there is an easier way to remove the space from the middle of a cell in Excel. You can use the SUBSTITUTE function to replace the space with nothing. Here are the steps to do it:

1. Select the column that contains the cells with the spaces you want to remove.
2. Click on the "Home" tab in the ribbon.
3. Click on the "Find & Select" button in the "Editing" group, and then select "Replace" from the dropdown menu.
4. In the "Find what" field, type a space character (press the spacebar once).
5. Leave the "Replace with" field blank.
6. Click on the "Replace All" button.
7. Click on the "OK" button to confirm that you want to replace all instances of the space character with nothing.

This will remove all spaces from the selected column, leaving only the numbers. Note that this will replace all spaces in the column, so make sure you don't have any spaces that you want to keep.