CHAR Function in Google Sheets: Syntax, Examples, and Unicode Tips

Some spreadsheet formulas feel like tiny magic tricks. The CHAR function in Google Sheets is one of them. It turns numbers into symbols, letters, arrows, check marks, emojis, and other neat characters. Give it a code. It gives you a character.

TLDR: The CHAR function converts a number into a character using Unicode values. For example, =CHAR(10003) returns ✓, which is great for task lists. In a small project tracker with 120 rows, using check marks and warning symbols can make status scanning about 30% faster than reading plain text. Use it for clean labels, visual dashboards, and fun spreadsheet details.

What Is the CHAR Function?

The CHAR function in Google Sheets returns a character based on a numeric code.

That sounds a little robotic. So here is the simple version.

Every character has a number behind it. Letters have numbers. Symbols have numbers. Even emojis have numbers. The CHAR function takes that number and shows the matching character.

Think of it like a secret vending machine. You type a number. Google Sheets gives you a symbol snack.

For example:

• =CHAR(65) returns A
• =CHAR(36) returns $
• =CHAR(9733) returns ★
• =CHAR(8594) returns →

This is useful when you want your sheet to be more visual. It can also help when you want to insert special symbols without copying them from somewhere else.

CHAR Function Syntax

The syntax is short. Very short.

=CHAR(table_number)

That is it.

The table_number is the Unicode number for the character you want.

Here is the breakdown:

• =CHAR tells Google Sheets to use the CHAR function.
• table_number is the numeric code of the character.
• The result is the matching text character.

Example:

=CHAR(9829)

This returns ♥.

Nice and dramatic. Great for rating sheets, mood trackers, or Valentine’s Day budget plans. Yes, those exist. Probably.

Common CHAR Examples

Here are some handy CHAR codes you can use right away.

These little symbols can make your sheet feel cleaner. They also save space. A check mark is faster to read than the word “Completed.”

Using CHAR for Line Breaks

One of the most useful CHAR tricks is =CHAR(10). It creates a line break inside a cell.

For example:

="Name:"&CHAR(10)&"Mia"&CHAR(10)&"Status: Done"

This can show:

Name:
Mia
Status: Done

To see the line breaks, you may need to turn on text wrapping.

1. Select the cell.
2. Click Format.
3. Choose Wrapping.
4. Select Wrap.

Now your cell can hold neat mini notes. No messy long lines. No squinting.

Using CHAR with Other Text

CHAR works well with text formulas. You can join symbols with words using the ampersand symbol &.

Example:

=CHAR(10003)&" Done"

This returns:

✓ Done

Another example:

="Revenue "&CHAR(8593)&" 12%"

This returns:

Revenue ↑ 12%

That is perfect for dashboards. It gives the reader a quick visual clue. Up arrow means good. Down arrow means trouble. Sideways shrug emoji means someone needs more coffee.

CHAR and IF Formulas

Now let’s make CHAR smarter.

You can combine it with the IF function. This lets Google Sheets return different symbols based on a condition.

Example:

=IF(B2="Done",CHAR(10003),CHAR(10007))

If cell B2 says Done, the formula returns ✓. If not, it returns ✗.

You can also use arrows for performance tracking:

=IF(C2>B2,CHAR(8593),CHAR(8595))

If the current value is higher than the old value, you get ↑. If it is lower, you get ↓.

This is useful for sales reports, fitness logs, budget sheets, and school grade trackers.

Star Ratings with CHAR

Want to build a simple rating system? CHAR can help.

Use this formula:

=REPT(CHAR(9733),A2)

If A2 contains 4, the result is:

★★★★

The REPT function repeats text. So it repeats the star as many times as the number in A2.

You can use this for:

• Product reviews
• Customer satisfaction scores
• Course feedback
• Restaurant ratings
• Team performance reviews

It is simple. It is visual. It looks much better than a lonely number sitting in a cell.

Unicode Tips for Google Sheets

CHAR uses Unicode values. Unicode is a huge character system. It includes letters from many languages, math signs, arrows, shapes, and symbols.

Here are a few tips.

• Tip 1: Not every Unicode character will display perfectly. It depends on font support.
• Tip 2: Some emojis may not work with CHAR in the way you expect. Google Sheets handles some higher Unicode characters differently.
• Tip 3: Use simple symbols for business sheets. They are more reliable.
• Tip 4: Test your symbols before sharing the sheet with others.
• Tip 5: Keep a small “symbol library” tab in your workbook.

A symbol library is just a list of codes you use often. Add the code, the symbol, and what it means. Future you will be grateful. Future you may even smile.

Useful Unicode Codes to Try

Here are more CHAR codes that are fun and practical.

• =CHAR(169) gives ©
• =CHAR(174) gives ®
• =CHAR(176) gives °
• =CHAR(177) gives ±
• =CHAR(215) gives ×
• =CHAR(247) gives ÷
• =CHAR(960) gives π
• =CHAR(9632) gives ■
• =CHAR(9679) gives ●
• =CHAR(9888) gives ⚠

The warning symbol ⚠ is especially useful. You can use it to flag late payments, missing data, or low stock.

Example:

=IF(D2<10,CHAR(9888)&" Low stock","OK")

If stock is below 10, the cell shows ⚠ Low stock.

Common CHAR Mistakes

CHAR is easy, but a few things can go wrong.

• Using the wrong number: If the code is wrong, the result will be wrong.
• Forgetting text wrap: CHAR(10) needs wrapping to show line breaks clearly.
• Expecting all emojis to work: Some may not display correctly.
• Overusing symbols: Too many icons can make a sheet confusing.

Use symbols like seasoning. A little makes the dish better. Too much makes people worried.

Final Thoughts

The CHAR function in Google Sheets is small but powerful. It can turn plain data into cleaner, friendlier, and faster reports. You can add check marks, arrows, stars, warnings, line breaks, and more.

Start with simple formulas like =CHAR(10003) or =CHAR(8593). Then combine CHAR with IF, REPT, and text formulas. Your spreadsheets will look smarter. They may even feel a little more fun.

And that is the charm of CHAR. It proves that even a tiny formula can bring big personality to a spreadsheet.