The UNICODE function returns the decimal Unicode value of the first character of the text.
Parts of a UNICODE function
UNICODE(text)
| Part | Description |
|---|---|
| text | The string containing the character to be evaluated. |
Sample formulas
UNICODE(“A”)
UNICODE(123)
UNICODE(😀😀😄)
Notes
- The UNICODE function will only work properly if the input string is not empty and the first character has a Unicode representation.
- Numbers may be passed directly into the UNICODE function and will be parsed as a string.
Examples
UNICODE : General Usage
| A | B | |
|---|---|---|
| 1 | Result | Formula |
| 2 | 65 | =UNICODE(“Alphabet”) |
| 3 | 49 | =UNICODE(123) |
| 4 | 128512 | =UNICODE(😀😀😄) |
Related functions
CHAR: Convert a number into a character according to the current Unicode table.
CODE: Returns the numeric Unicode map value of the first character in the string provided.