UNICHAR Function in Excel: Any Unicode Symbol

📎 This article includes 1 downloadable practice file ↓

TextLevel: IntermediateAvailable in: Excel 2013+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. UNICHAR in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

UNICHAR returns a character from its Unicode number — arrows, ticks, the rupee sign — without hunting through Insert › Symbol.

Syntax

=UNICHAR(number)

Argument	What it means
number	Unicode code point.

Examples

Example 1

=IF(C2>B2, UNICHAR(9650), UNICHAR(9660))

▲ or ▼ next to a KPI.

Example 2

=UNICHAR(8377)&TEXT(A2,"#,##0")

Prefix the ₹ sign.

UNICHAR in practice

Where you will use it

• Add ₹ symbol, ticks or emoji
• Indian script characters
• Arrows in reports

Worked example

Code	Formula	Result
8377	=UNICHAR(A2)	₹
10004	=UNICHAR(A3)	✔
2309	=UNICHAR(A4)	अ

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Font lacks the glyph	Use a font like Segoe UI Symbol
Codes in hex	Convert with HEX2DEC first

Related functions

CHAR · UNICODE · REPT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Text guides →

REGEXREPLACE Function in Excel: Find and Replace With PatternsREGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask…T Function in Excel: Keep Text, Blank Out NumbersT returns text unchanged and anything else as an empty string. Rarely needed alone,…NUMBERVALUE Function in Excel: Convert Text Numbers With Any SeparatorsNUMBERVALUE converts text to a number using separators you specify — essential for European-style…VALUE Function in Excel: Convert Text to a NumberVALUE turns text that looks like a number into a real number, so SUM…

📎 Practice files for this article

• 📗
  Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.