UNICHAR

Excel Functions

Get Unicode character by number

Syntax

EXCEL

=UNICHAR(number)

Arguments

Parameter	Description
`number`	Code point for a Unicode character in decimal.

Return Value

Unicode character

Details

The UNICHAR function returns the Unicode character at a given code point, provided as a number in decimal format. To illustrate, the Euro symbol (€) has a code point of 8364 in decimal notation. The following formula will return the Euro character: Unicode assigns each character a unique numeric value and name. This numeric value is referred to as a "code point". Code points are typically represented by the "U+" notation followed by hexadecimal numbers. For example, the code point for the capital letter A is U+0041, and the code point for the "😊" emoji is U+1F60A. It is important to understand that the UNICHAR function does not accept Unicode numbers in hexadecimal format, it requires numbers in decimal format. In decimal representation, the code point for "A" is 65, and the code point fo

Examples

Example 1

The UNICHAR function returns the Unicode character at a given code point, provided as a number in decimal format. To illustrate, the Euro symbol (€) h

EXCEL

=UNICHAR(8364) // returns euro sign "€"

Unicode numbers

Unicode assigns each character a unique numeric value and name. This numeric value is referred to as a "code point". Code points are typically represe

EXCEL

=UNICHAR(65) // returns "A"
=UNICHAR(128522) // returns "😊"

Unicode numbers

In Excel, you can use the HEX2DEC function to translate numbers from hexadecimal to decimal if needed.

EXCEL

=UNICHAR(HEX2DEC("1F642")) // returns "🙂"

Examples

The Unicode character "★" is code point 9733 in decimal notation, therefore:

EXCEL

=UNICHAR(9733) // returns "★"

Examples

To display a different character, change the number to match the symbol you want:

EXCEL

=UNICHAR(10003) // returns "✓"
=UNICHAR(10007) // returns "✗"
=UNICHAR(128578) // returns "😊"

UNICHAR in a formula

The UNICHAR function offers a straightforward way to display a Unicode symbol in a formula. The formula below uses UNICHAR inside the IF function to d

EXCEL

=IF(C5="complete",UNICHAR(10003),"")

UNICHAR

Syntax

Arguments

Return Value

Details

Examples

See Also