Documentation/Calc Functions/UNICODE

Function name:
UNICODE

Category:
Text

Summary:
Determines the Unicode code point that corresponds to the first character of a given text string or number.

The UNICODE function is complementary to the UNICHAR function.

For some characters with code points in the range 0 ≤ n ≤ 255, UNICODE may return the same code point as the CODE function. However, for other characters with code points in the same range, the value returned by UNICODE may be different from that returned by CODE. This difference arises when CODE returns the code point for a system-specific character from the current coded character set.

Syntax:
UNICODE(Text)

Returns:
Returns an integer in the range 0 ≤ n ≤ 111411 (0x10FFF in hexadecimal), which is the Unicode code point that corresponds to the first character of the given text string or number.

Arguments:
Text is a text string (in quotation marks) or a number, or a reference to a cell containing such a string or number, the first character of which is the character whose code point is to be determined.


 * If Text is an empty string, then UNICODE reports Err:504 (error in parameter list).
 * If Text is a non-negative number, then UNICODE returns the code point corresponding to the first digit of that number. If Text is a negative number, then UNICODE returns the code point corresponding to the minus sign (which has a Unicode code point of 45).

Additional details:
For any code point n,

Related LibreOffice functions:
CHAR

CODE

UNICHAR

ODF standard:
Section 6.20.26, part 2

Equivalent Excel functions:
UNICODE