Hi everyone,

I have a project that required import from HTML source files into Excel. I won't go into the specifics, but the jist is that I have a number of cells that contain text with special characters (in a variety of languages), but are not displayed correctly. For example:

é should be displaying as é
EpÃ*logo should be displaying as Epílogo
etc. etc.

I've got about 9,000 cells in a single column that need to have the characters fixed.

I know I could manually go through and do a find/replace for specific characters, but I'm worried about missing some, and that being a real waste of time.

Any suggestions on the best method to resolve the issue? Thanks so much!