Excel Function - Convert unicode to ascii

Question

Is there any function in Excel (2010) which decode unicode to ascii text?

One column in my sheet contains word/sentences in Portuguese.

For Example:

Esse Jean é feio né

Should become

Esse Jean é feio né

é - This letter in the text is not Portuguese, is there any function to convert this to Portuguese font format i.e é.

How do I decode above text to original format Esse Jean é feio né in excel?

Answer 1

This sound an awful lot like you failed to import the data correctly.

If you still have the original data, I suggest you import it again and use 65001: Unicode (UTF-8).

If you do not have the original data, you can still trick Excel into importing your data again. I suggest you copy the incorrect column to it's own Excel file, then go to File and Export the new file to Text (Tab delimited). Next import (found under Data -> From Text), set the file type to Delimited and the File origin to 65001: Unicode (UTF-8).

You should now have a new Excel file with fixed encoding. Copy the column from the new file and paste it in the old file.