I have some extra spaces that pop up when copying data from a webpage.

Example:

123,123 comes into Excel as
123,123 with a space at the beginning and the end.

I am doing some calculations with these cells in a macro, and of course the
formula won't calculate until i delete the space at the beginning and the
end. What would be a good way to get rid of those spaces? There are many
cells, so a nice formula would be great, I can slip it into the macro and go
about my merry way.

Text to columns isn't seeming to work, The length of the data in the cells
varies from 2 numbers to a 8 numbers. Any advice will be useful, THANKS!!!