UNICODE

Formulas / UNICODE
Retrieve 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?
The UNICODE function is a built-in function of the programming language which returns the numerical code point for the text argument.
What is the syntax for the UNICODE function?
The syntax for the UNICODE function is text UNICODE.
Is the text argument required for the UNICODE function?
Yes, the text argument is required for the UNICODE function.
What is the text argument in the UNICODE function?
The text argument is the character to get the Unicode value for.
What happens if the text argument contains partial surrogates or invalid data types?
The UNICODE function will throw an error if the text argument contains partial surrogates or invalid data types.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV