To illustrate, the Euro symbol () has a code point of 8364 in decimal notation.
This numeric value is referred to as a “code point”.
Code points are typically represented by the “U+” notation followed by hexadecimal numbers.
Because Unicode is a superset of other character sets, it is very large.
The first 128 code points in Unicode align exactly with the ASCII characters.
Unicode can be implemented in different encodings, most commonly UTF-8 and UTF-16.
It is estimated that over 90% of websites on the internet use UTF-8.
UNICHAR versus UNICODE
The UNICHAR function translates a givencodein decimal number format into a Unicodecharacter.
To perform theopposite conversion,see theUNICODE function, which translates a Unicodecharacterinto acodein decimal number format.
CHAR can insert characters that are hard to enter into a formula.
…
CODE Function
The Excel CODE function returns a numeric code for a given character.
For example, CODE(“a”) returns the code 97….