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