Formulas > =UNICHAR()

How to Use UNICHAR() in Google Sheets

Description

Returns the Unicode character for a number..

How To Actually Use UNICHAR() in Sheets 

UNICHAR(number)

Try UNICHAR yourself

In cells A1:A10, enter numbers from 1 to 10. In cells B1:B10, use the UNICHAR formula to display the corresponding Unicode characters for those numbers.

Hints (2)
Separator ,

Related formulas

UNICHAR returns emoji and symbols above code point 255. In Google Sheets, CHAR covers the same range for most visual formulas.

  • CHAR for classic symbol lookups
  • UNICODE to find the code point of a character

Sheet art with UNICHAR

Sheet art examples with UNICHAR()

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

Star rating with Glowing Star

Put rating 0-5 in A1. Filled stars use UNICHAR(127775).

=REPT(UNICHAR(127775),MIN(A1,B1))&REPT(CHAR(11088),MAX(0,B1-A1))

🌟🌟🌟⭐⭐

REPT CHAR UNICHAR

Star rating with Black Star and New Moon blank

Put current count in A1 and goal in B1 (e.g. 5). Filled slots use black star, empty slots use new moon.

=REPT("★",MIN(A1,B1))&REPT(UNICHAR(127761),MAX(0,B1-A1))

★★★🌑🌑

REPT UNICHAR

Star rating with Black Star and Dotted Line Face blank

Put current count in A1 and goal in B1 (e.g. 5). Filled slots use black star, empty slots use dotted line face.

=REPT("★",MIN(A1,B1))&REPT(UNICHAR(129509),MAX(0,B1-A1))

★★★🫥🫥

REPT UNICHAR

Star rating with Black Star and Prohibited blank

Put current count in A1 and goal in B1 (e.g. 5). Filled slots use black star, empty slots use prohibited.

=REPT("★",MIN(A1,B1))&REPT(UNICHAR(128683),MAX(0,B1-A1))

★★★🚫🚫

REPT UNICHAR

Star rating with White Star and New Moon blank

Put current count in A1 and goal in B1 (e.g. 5). Filled slots use white star, empty slots use new moon.

=REPT(CHAR(9734),MIN(A1,B1))&REPT(UNICHAR(127761),MAX(0,B1-A1))

☆☆☆🌑🌑

REPT CHAR UNICHAR

Star rating with Black Star and Black Square Button blank

Put current count in A1 and goal in B1 (e.g. 5). Filled slots use black star, empty slots use black square button.

=REPT("★",MIN(A1,B1))&REPT(UNICHAR(128274),MAX(0,B1-A1))

★★★🔲🔲

REPT UNICHAR
Browse Scenes (43 formulas) All 2054 Playground formulas
Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

More related tutorials

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

Browse more tutorials
REGEXMATCH Formula Generator for Google Sheets

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...
Advanced
IF() REGEXMATCH()
Write Apps Script to Create a New Google Sheets Formula

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 ...
One Weird Google Sheet Formula for Bulk Publishing With AI

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your da...
Intermediate
IF() ISBLANK() SUBSTITUTE()
Create a Trello Board with Transpose Formula in Google Sheets

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making applica...
Most Popular Intermediate
TRANSPOSE()
Unlock these tutorials

Learn more about the UNICHAR() formula:

Generate a UNICHAR() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses UNICHAR(). 2 free AI generations, no signup. Members get unlimited use.

Generate a UNICHAR() formula

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons