UNICODE

• How to use UNICODE formula?
• Examples of using UNICODE formula
• UNICODE formula not working?
• Similar formulas to UNICODE

Usage

Use the UNICODE formula with the syntax shown below, it has 1 required parameter:

=UNICODE(text)

1. text (required):
   The text for which to return the Unicode code point. Must be enclosed in quotation marks.

Examples

Extracting the Unicode code point of a character

UNICODE can be used to extract the numerical value of a single character in a string of text. This can be helpful when working with non-Latin text or when analyzing specific characters within a larger text string.

Comparing Unicode code points

Because each character in a text string has a unique Unicode code point, UNICODE can be used to compare characters in different languages or character sets. This can be useful when analyzing data that contains text in multiple languages.

Converting text to its Unicode code point equivalent

UNICODE can be used to convert a string of text into a series of numerical values, each representing the Unicode code point of a character in the text. This can be helpful when working with complex text data or when creating custom data analysis tools.

Common Mistakes

Not using quotes around text parameter

The UNICODE function requires the text parameter to be enclosed in quotes. If the parameter is not enclosed in quotes, the function will return a #VALUE! error.

Using a range reference as the text parameter

The UNICODE function requires a single cell reference or a quoted text string as the text parameter. If a range reference is used as the text parameter, the function will return a #VALUE! error.

Related Formulas

The following functions are similar to UNICODE or are often used with it in a formula:

• CHAR

  The CHAR formula returns the character corresponding to the ASCII code provided. This formula is commonly used to convert a numerical value to its corresponding character in a Google Sheets cell.

• CODE

  The CODE formula returns the numeric Unicode value of the first character in a text string. This can be useful when working with non-English characters or when attempting to identify certain characters in a text string.

• LEN

  The LEN formula in Google Sheets is used to count the number of characters in a given text string. It is commonly used to check the length of text inputs, or to find the length of a cell value or range.

• LEFT

  The LEFT formula is used to extract a specific number of characters from the beginning of a text string. It is most commonly used to extract the first name or last name from a full name or to extract a date from a text string.

• RIGHT

  The RIGHT formula in Google Sheets returns the rightmost characters from a string, based on the number of characters specified. It is commonly used to extract a certain number of characters from the end of a string. The formula takes two arguments: the string from which to extract the characters, and the number of characters to extract.

Learn More

You can learn more about the UNICODE Google Sheets function on Google Support.