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.

Useful Unicode symbols in Excel

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.

Useful Unicode symbols in Excel

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.

Useful Unicode symbols in Excel

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….

Useful Unicode symbols in Excel

Useful Unicode symbols in Excel

If function with unichar function to display checkmark

If function with unicode x character

Excel formula: If complete show checkmark

Excel UNICHAR function

Excel CHAR function

Excel UNICODE function

Excel CODE function

Useful Unicode symbols in Excel