Enable the Analysis Add-in for Excel to eliminate special characters in your excel workbooks.