David McRitchie has some code that will help clean this stuff up:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()")

Richard wrote:

I copied a table of number from the web into Excel but I can not do basic
functions with the numbers. Is there some quick way to convert all of the
numbers?

Thank you in advance

Richard

--

Dave Peterson