Formulas > =CHAR()
How To Use CHAR() Function in Google Sheets
Description
How To Actually Use CHAR() in Sheets
CHAR(table_number)
Try CHAR yourself
In cells A1:A10, enter numbers from 65 to 74. In cell B1, use the CHAR formula to convert the number in A1 to its corresponding character. Drag the formula down to B10 to fill the rest of the cells.
Hints (3)
-
Remember that CHAR uses the Unicode table.
-
The number 65 corresponds to 'A'.
-
Make sure to drag the formula down to apply it to other cells.
Related formulas
CHAR turns a number into a character. CODE does the reverse: it turns a character into a number.
Browse all characters
Open the CHAR Google Sheets character table to browse glyphs visually, copy =CHAR(n) formulas, and see fun REPT() examples.
2 Better Sheets Tutorials
Build The Dashboard - Design a Better Dashboard Part 3
We're actually gonna go build the dashboard today.
CHAR()
COUNTA()
HYPERLINK()
IF()
INDEX()
+2 more
5 Ways to Create Coupon Codes | Create UUIDs
Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.
CHAR()
DEC2HEX()
MID()
RANDBETWEEN()
Learn more about the CHAR() formula:
Generate a CHAR() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses CHAR(). 2 free AI generations, no signup. Members get unlimited use.
Generate a CHAR() formula