How to Use UNICODE function in Google Sheets in 2020?

UNICODE functionThe 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.