Run this macro


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

Regards,

Peo Sjoblom


"Richard" wrote:

Is there a quick way to format numbers copied from a website into Excel.

I find that the numbers copied into Excel do not allow any operations to be
performed.

Thank you in advance for your help.