Special Characters in MS excel

I am extracting data from one of our ERP software and when i do that in CSV then some of the data is coming in special characters because of which my formula is getting messed up. Can any one please ...