Excel functions / Text
UNICODE function
The Unicode number of the first character of some text.
Syntax
=UNICODE(text)
Arguments
text: The text.
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
The euro sign
A B C 1 Text 2 € 8364 In C2:
=UNICODE(A2)→ 8364A plain letter
A B C 1 Text 2 a 97 In C2:
=UNICODE(A2)→ 97
Common mistakes
- Only the first character. UNICODE reads one character. Cut out the one you want with MID first.
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.
- Czech: UNICODE
- Danish: UNICODE
- Dutch: UNICODE
- Finnish: UNICODE
- French: UNICODE
- German: UNICODE
- Hungarian: UNICODE
- Italian: UNICODE
- Norwegian: UNICODE
- Polish: UNICODE
- Portuguese (Brazil): UNICODE
- Portuguese (Portugal): UNICODE
- Russian: UNICODE
- Spanish: UNICODE
- Swedish: UNICODE
- Turkish: UNICODE