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 1828 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

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

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons