[Aaron]

I have a file that I have downloaded to excel from the Web. The format is showing alot of NonBreaking spaces which is not allowing me to SUM the numbers. HOw do I get rid of these after it is in Excel

Thanks
Aaron

 

[JE McGimpsey]

Check out David McRitchie's TRIMALL():

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