UNICHAR
TheUNICHAR
function returns the Unicode character represented by the given numeric value. This is useful when working with nonLatin 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
UNICHAR
formula?  Examples of using
UNICHAR
formula UNICHAR
formula not working? Similar formulas to
UNICHAR
Usage
Use the 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.
Examples
Here are a few example use cases that explain how to use theUNICHAR
formula in Google Sheets.
Convert Unicode values to characters
The 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 nonLatin 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
The 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
The 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.
Common Mistakes
UNICHAR
not working? Here are some common mistakes people make when using the UNICHAR
Google Sheets Formula:
Using nonnumeric input
The UNICHAR
function requires a numeric input, but if you provide a nonnumeric input, it will return an error. Make sure to only provide numerical input.
Providing invalid Unicode number
The 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.
Related Formulas
The following functions are similar to UNICHAR
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. 
UNICODE
The UNICODE formula returns the Unicode code point of the first character of the text. This can be useful when working with nonLatin text, such as Asian or Cyrillic languages. It can be used in conjunction with other formulas to manipulate and analyze text data.

CONCATENATE
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.
Learn More
You can learn more about the UNICHAR
Google Sheets function on Google Support.