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 help me with that. I want to the letter/character as it is.

Thanks in Advance.