Excel offers a CODE () function which returns the ASCII code for a given character. This is basically the reverse of the CHAR () function which is used to translate a numerical code into a character.

Hey folks --I am having an issue with fields within my Excel spreadsheet provided by a client being encoded in some unique character set.Here's one such example:Shown in Excel: Amex Non – PPS ...

In one of the Excel sheets from work I noticed it had a name that was in kanji and it was being displayed as gibberish so I just tried other CJK character sets and it seems that Excel 2011 can't ...