Excel functions / Text

UNICHAR function

The character with a Unicode number: letters of any alphabet, symbols, emoji.

Syntax

=UNICHAR(number)

Arguments

When to use it

UNICHAR gives the character with a given Unicode number: any letter, symbol or arrow. It is how a formula puts a tick, a cross or an arrow into a cell.

Examples

  1. A tick or a cross

    ABCD
    1NameScore
    2Ana72✓
    3Ben48
    4Chloe90
    5Dev65
    6Eve81

    In D2: =IF(B2>=50, UNICHAR(10003), UNICHAR(10007)) → ✓

    Try this example

  2. An arrow

    ABC
    1Code
    28593↑

    In C2: =UNICHAR(A2) → ↑

    Try this example

Common mistakes

UNICHAR in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try UNICHAR in the playground

Related functions