I recently had to copy a large amount of data from my company's website.
When I copied it over to Excel all cells had trailing spaces, 5 spaces
to be exact.

What I need to know is how do I sweep through and get rid of all those
extra spaces. They are interferring with calculations and sorting of
numbers.

Thanks for all your help.


--
shane24
------------------------------------------------------------------------
shane24's Profile: http://www.excelforum.com/member.php...fo&userid=4770
View this thread: http://www.excelforum.com/showthread...hreadid=490089