Try the macro at this site:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

It's free! (and it works!)

Biff

"Robert M. Gary" wrote in message
ups.com...
If I copy/paste a table from a browser into Excel it seems I can never
remove the spaces before/after the numbers in the cells. I've used
=value(trim(clear(B1))) and then copy/pastespecial(values) but still I
get "10 " (with the end space). Its very frustrating because I cannot
sum the column. I see there is add on software that you can buy to
remove spaces from cells but it seems so very ridiculous that Microsoft
hasn't solved this yet.
The only valuable suggestion I can find on the MS site is to retype the
numbers. I believe they think copy/paste may be overrated.

-Robert