Excel 2007 : Remove Extra Space

How do I remove the extra spaces so the numbers match when I run the pivot table. The total should be 4 instead of 2, since the numbers are the same.


Is there an easier way to do this beside going in front of the number and deleting the extra space.

I tried using the paint brush to match properties but it didn't work