How to use UNICHAR Google Sheets formula?

The syntax for the UNICHAR formula is =UNICHAR(number), it has 1 required parameter.

Why is UNICHAR Google Sheets formula not working?

One common reason the UNICHAR formula may not be working is due to using non-numeric input. The <code>UNICHAR</code> 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.

UNICHAR

The UNICHAR function 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 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:

=UNICHAR(number)

Parameters:

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 the UNICHAR 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 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

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 non-numeric input

The 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

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.

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 non-Latin 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.