Returns the number (code point) corresponding to the first character of the text.
Синтаксис
UNICODE(text)Аргументы
textобязательно
The character or string for which you want to find the Unicode code point.
The UNICODE function returns the Unicode code point for the first character of a supplied text string. It is the inverse of the UNICHAR function and is useful for identifying the unique numeric identifier of characters in various scripts.
=UNICODE("A")→65Returns the Unicode code point for the uppercase letter A.
=UNICODE("€")→8364Returns the Unicode code point for the Euro currency symbol.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =UNICODE( followed by the text string in quotes or a cell reference, then close the parenthesis.
Press Enter
Press Enter to calculate the code point value.
CODE returns the numeric code for the first character in the local character set (ANSI), while UNICODE returns the Unicode code point, which supports a much wider range of international characters.