UNICODEThe UNICODE formula returns the Unicode code point of the first character of the text. This can be useful when working with non-Latin text, such as Asian or Cyrillic languages. It can be used in conjunction with other formulas to manipulate and analyze text data.
- How to use
- Examples of using
UNICODEformula not working?
- Similar formulas to
UNICODE formula with the syntax shown below, it has 1 required parameter:
- text (required):
The text for which to return the Unicode code point. Must be enclosed in quotation marks.
ExamplesHere are a few example use cases that explain how to use the
UNICODE formula in Google Sheets.
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.
UNICODE not working? Here are some common mistakes people make when using the
UNICODE Google Sheets Formula:
Not using quotes around text parameter
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
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.
The following functions are similar to
UNICODE or are often used with it in a formula:
CHARformula 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.
CODEformula 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.
LENformula 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.
LEFTformula 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.
RIGHTformula 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.
You can learn more about the
UNICODE Google Sheets function on Google Support.