Better Sheets

CHAR Google Sheets Formula

Description

Convert a number into a character according to the current Unicode table.

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.

Your formula

Hints (3)

Locale Separator ,

Related formulas

CHAR turns a number into a character. CODE does the reverse: it turns a character into a number.

CODE returns the numeric value of a character
UNICODE also returns the numeric value
UNICHAR is like CHAR for Unicode in Excel

Browse all characters

Open the CHAR Google Sheets character table to browse glyphs visually, copy =CHAR(n) formulas, and see fun REPT() examples.

Sheet art with CHAR and REPT

Combine CHAR with REPT to build progress bars, star ratings, and other in-cell visuals in Google Sheets.

Sheet art examples with CHAR()

10 copy-paste formulas from the Playground use CHAR(). Click a card to copy the full formula into Google Sheets. Showing a curated set from 776 matching examples.

Yes / No checkmarks

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes","✗ No")

✔ Yes

IF CHAR

Box border cell

Put inner width in A1. Draws a box around empty space.

="┌"&REPT("─",A1)&"┐"&CHAR(10)&"│"&REPT(" ",A1)&"│"&CHAR(10)&"└"&REPT("─",A1)&"┘"

┌────┐ │ │ └────┘

REPT CHAR

Bullet list char

Put list text in B1. Adds a bullet prefix.

=CHAR(8226)&" "&B1

• Item

CHAR

Writing pace and progress

Put word count in A1, goal in B1, total days in C1, and current day in D1. Shows percent done and pace needed.

="Progress: "&TEXT(A1/B1,"0%")&CHAR(10)&"Pace: "&TEXT(MAX(0,ROUND((B1-A1)/MAX(1,C1-D1),0)),"#,##0")&" words/day"

Progress: 50% Pace: 1,667 words/day

TEXT CHAR ROUND MAX

Writing dashboard

Put word count in A1, goal in B1, total days in C1, and current day in D1. Count, percent, and daily pace in one cell.

="📊 "&TEXT(A1,"#,##0")&"/"&TEXT(B1,"#,##0")&CHAR(10)&"📈 "&TEXT(A1/B1,"0%")&" done"&CHAR(10)&"⏱️ "&TEXT(MAX(0,ROUND((B1-A1)/MAX(1,C1-D1),0)),"#,##0")&"/day"

📊 24,891/50,000 📈 50% done ⏱️ 1,667/day

TEXT CHAR ROUND MAX

Dark shade progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Ten shaded blocks fill left to right.

=REPT(CHAR(9619),MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

▓▓▓▓▓▓▓▓░░

REPT CHAR ROUND MIN MAX

Medium block progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Medium blocks with light empty slots.

=REPT(CHAR(9604),MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

▄▄▄▄▄▄░░░░

REPT CHAR ROUND MIN MAX

Trophy goal progress bar

Put current value in A1 and goal in B1 (e.g. 10). Blocks fill toward a trophy at the end.

=REPT(CHAR(9608),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&"🏆"

█████░░░░░🏆

REPT CHAR MIN MAX

Year Progress dark shade bar

Shows year progress from TODAY() with dark shaded blocks. Ten segments fill as the year advances. No input needed.

=REPT(CHAR(9619),MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))

▓▓▓▓▓░░░░░

REPT CHAR DATE YEAR TODAY ROUND MIN MAX

Year Progress dark shade bar with percent

Shows year progress from TODAY() as a dark shade bar plus a percent label. Updates daily. No input needed.

=REPT(CHAR(9619),MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0))))&REPT(CHAR(9617),MAX(0,10-MIN(10,MAX(0,ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*10,0)))))&" "&ROUND((TODAY()-DATE(YEAR(TODAY()),1,1))/(DATE(YEAR(TODAY()),12,31)-DATE(YEAR(TODAY()),1,1))*100,0)&"%"

▓▓▓▓▓░░░░░ 53%

REPT CHAR DATE YEAR TODAY ROUND MIN MAX

Browse Ratings (377 formulas) All 2054 Playground formulas

Official Docs

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()

Transcript-matched member videos for CHAR(). Click through to watch.

Browse more tutorials

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Unlock these tutorials

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