Would anyone know how to find cells with leading spaces and then remove them? A co-worker has over 500 rows of items that need to be sorted, unfortunately about 350 of the cells appear to have leading spaces before the entries so the sort will not work properly. Is there a "relatively" simple way to find and replace these spaces? We're using XL 2K with Win NT and 98. Thanks for your help.