Go with third party Excel Repair Tool, this tool extracts all corrupted data items such as text even from heavily damaged *.xls files. It helps you to fix all corruption issue and save them in new usable Excel file. To know more-
http://www.datarepairtools.com/excel-recovery.html