Returns the number (code point) corresponding to the first character of the text.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
UNICODE(text)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")תוצאה: 65
Returns the Unicode code point for the uppercase letter A.
=UNICODE("€")תוצאה: 8364
Returns the Unicode code point for the Euro currency symbol.
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.