Arrow left
Back to guides
Google Sheets Formulas

CHAR Function in Google Sheets: Explained

In this article, you will learn how to use the CHAR formula in Google Sheets.

What does the CHAR function do in Google Sheets?

The CHAR formula allows you to convert a number to a character, such as a special symbol, based on the Unicode table.

How to use the CHAR formula in Google Sheets

  1. Type “=CHAR” or go to “Insert”“Function” (or directly navigate to the “Functions” icon)  “Text”“CHAR”.
  2. Input a decimal Unicode by manual input or cell reference.
  3. Press the “Enter” key.
How to insert the CHAR function from the menu bar in Google Sheets

The general syntax of the CHAR function is as follows:


Table_number: this argument should be a number corresponding to one of the decimal Unicodes. Note that hex Unicode doesn’t work for the CHAR formula.

As you can see in the following screens, it is simple to use this formula. Once you input and select the appropriate Unicode, the formula automatically retrieves the symbol corresponding to the code. You can use this formula to decorate your table (when applicable) or visualize data. For instance, you can learn how to use the REPT function with the CHAR function in this article: REPT Function in Google Sheets: Explained

How the CAHR function works in Google Sheets with examples

What is the formula for character count in Google Sheets?

You can count the number of characters in a text string with the LEN function. To learn the LEN formula, check this article: LEN Function in Google Sheets: Explained

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below