UNICODE
Formulas / UNICODERetrieve the number from a Unicode character.
UNICODE(text)
- text - required, the text to get the Unicode value for
Examples
=UNICODE("A")The function can be used to return the Unicode number that a character represents. For example, if you use the function above, it will return the Unicode number for the uppercase "A", which is 65.
=UNICODE("&")The function can also be used to return the Unicode number that a special character represents. For example, if you use the function above, it will return the Unicode number for the ampersand character, which is 38.
=UNICODE(" ")The function can also be used to return the Unicode number that a space character represents. For example, if you use the function above, it will return the Unicode number for a single space inside quotation marks, which is 32.
=UNICODE("1")The function can also be used to return the Unicode number that a number character represents. For example, if you use the function above, it will return the Unicode number for the number 1, which is 49.
Summary
The UNICODE function is used to obtain the Unicode code point for a given text argument. It requires one text argument and provides the corresponding Unicode code point.
- The UNICODE standard is a set of rules for encoding, representing, and handling text in most of the world's writing systems. The UNICODE function returns a character corresponding to a number.
Frequently Asked Questions
What is the UNICODE function?
What is the syntax for the UNICODE function?
Is the text argument required for the UNICODE function?
What is the text argument in the UNICODE function?
What happens if the text argument contains partial surrogates or invalid data types?
