UNICHARfunction returns the Unicode character represented by the given numeric value. This is useful when working with non-Latin characters or symbols that cannot be easily typed on a keyboard. The function takes a single parameter, a number representing the Unicode value of the character to be returned.
- How to use
- Examples of using
UNICHARformula not working?
- Similar formulas to
UNICHAR formula with the syntax shown below, it has 1 required parameter:
- number (required):
The Unicode value of the character to be returned. This must be a positive integer between 0 and 1,114,111, inclusive.
ExamplesHere are a few example use cases that explain how to use the
UNICHARformula in Google Sheets.
Convert Unicode values to characters
UNICHAR function can be used to convert a list of Unicode values to their corresponding characters. This is useful when working with data that contains non-Latin characters or symbols. For example, suppose you have a list of Unicode values in column A and you want to display the corresponding characters in column B. You can use the formula
=UNICHAR(A1) in cell B1 and copy it down to the rest of the column.
Create custom bullet points
UNICHAR function can be used to create custom bullet points in a list. For example, suppose you want to create a list with bullet points that look like stars. You can use the formula
=UNICHAR(9733)&" "&A1 to add a star to the beginning of each item in the list.
Display special symbols
UNICHAR function can be used to display special symbols in a spreadsheet. For example, suppose you want to display a check mark next to a task that has been completed. You can use the formula
=IF(A1,""&UNICHAR(10003),"") to display a check mark in cell B1 if the value in cell A1 is true.
UNICHARnot working? Here are some common mistakes people make when using the
UNICHARGoogle Sheets Formula:
Using non-numeric input
UNICHAR function requires a numeric input, but if you provide a non-numeric input, it will return an error. Make sure to only provide numerical input.
Providing invalid Unicode number
UNICHAR function requires a Unicode number between 1 and 1,114,111. If you provide a number outside of this range, it will return an error. Make sure to only provide valid Unicode numbers.
The following functions are similar to
UNICHAR 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.
The 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.
The CONCATENATE function in Google Sheets is used to combine text strings from different cells or inputted directly in the formula. It takes one or more text strings as input and returns a single concatenated string. This function is commonly used to combine first and last names, or to merge data from multiple cells into a single cell.
You can learn more about the
UNICHAR Google Sheets function on Google Support.