ProductSolutionsTemplatesResources

UNICHAR

Returns the Unicode character for a number. Learn more.

Video field
Text

The UNICHAR(number) function in Google Sheets is used to convert a decimal Unicode number into its corresponding character.

Unicode is a standard system that assigns unique numbers to almost every character from various writing systems, including alphabets, symbols, and emojis.

The UNICHAR() function takes a decimal number as an argument and returns the character associated with that Unicode number.

For example, if you use the formula "=UNICHAR(65)" in a cell, it will display the uppercase letter "A" because the Unicode value for "A" is 65.

Here's an example to illustrate its usage:

Enter the number "65" in cell A1.

In cell B1, enter the formula "=UNICHAR(A1)".

The cell B1 will display the character "A" since the Unicode value 65 corresponds to the uppercase letter "A".

You can also use this function with cell references or as part of more complex formulas to work with a range of Unicode numbers and characters.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!