TL:DR; Use this application to find and extract emails in your Excel files.
Download Excel Extract Email Addresses Softw Shareware - Rating: 4.90
Quickly clear out text and spaces for cells in Excel using numerous methods. These methods include: removing spaces, removing alpha, numeric and more, removing characters after a word, removing characters after a certain position.
Microsoft recommends several methods for recovering Excel data from corrupt spreadsheets. This freeware add-in brings them into one place. It also adds 2 extraction and 1 repair methods of its own as well as an earlier file version recovery
This nifty add-in for Excel 2000-2010 will help you remove leading and trailing spaces, excess spaces between words, unbreakable spaces and non-printing characters; convert words to a proper case and change numbers formatted as text to numbers.