Wauvel

Excel like a finance pro.

← The library

Text function

UNICHAR

Returns the Unicode character for a number.

OccasionalDifficulty 1150 · ProficientUsage rank #187 of 520
Practice · 2 questions →

When to use it

The character for any Unicode code point. Check marks, arrows, emoji, and currency symbols.

The shape of it

Syntax
=UNICHAR(number)

Worked examples

  • Currency

    =UNICHAR(8364) → €

    The euro sign.

  • Check box

    =UNICHAR(9745) → ☑

    A checked box.

  • Check mark

    =UNICHAR(10003) → ✓

    A check mark for status columns.

Worth knowing

  • Conditional icons: IF(done,UNICHAR(10003),UNICHAR(10007)).
  • Block bars: REPT(UNICHAR(9608),n).
  • Find code points at unicode-table.com or with UNICODE.

Where it goes wrong

  • #VALUE! for 0 or invalid code points.
  • The font must contain the character or you see a box.

Related

LEFTRIGHTLENTRIMUPPERLOWER

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.