I copied a bunch of economic data and I am trying to do calculations with it. Only problem is that the original source contained extra spaces, so Excel doesn't recognize the data as numbers.

For instance, instead of "9.9", it would be "9.9 " with the extra space. All the data in my spreadsheet is like this.

Is there any way to correct this all at once, without manually deleting spaces in the spreadsheet?