ReferenceFunctionsText Functions
UNICODE
Returns the Unicode code point of the first character in text.
Summary
Returns the Unicode code point of the first character in text.
Remarks
- Only the first character is evaluated.
- Empty text returns
#VALUE!. - Non-text inputs are coerced to text before inspection.
- Errors are propagated unchanged.
Examples
Code point for letter A
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
65
Code point for emoji
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
128512
Related functions
FAQ
If text has multiple characters, which one is used?
UNICODE inspects only the first character and ignores the rest.
Runtime metadata
Category
Text
Signature
UNICODE(arg1: Any)Arity
min 1, max 1
Arguments
arg1Any ยท Scalar
Caps
PURE
Source