Excel functions / Text

UNICODE function

The Unicode number of the first character of some text.

Syntax

=UNICODE(text)

Arguments

When to use it

UNICODE gives the Unicode number of the first character of a text. Unlike CODE it covers every alphabet and symbol, which makes it the one to use for anything beyond plain English letters.

Examples

  1. The euro sign

    ABC
    1Text
    2€8364

    In C2: =UNICODE(A2) → 8364

    Try this example

  2. A plain letter

    ABC
    1Text
    2a97

    In C2: =UNICODE(A2) → 97

    Try this example

Common mistakes

UNICODE 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 UNICODE in the playground

Related functions