Skip to content
ExcelExcel 2013+

UNICHAR function in Excel

Returns the Unicode character that is references by the given numeric value

=UNICHAR(number)

UNICHAR syntax and parameters

One argument, one required.

  • numbernumberRequired

    Number is the Unicode number that represents the character.

UNICHAR examples

Formulas you'll actually reuse.

  1. The euro sign from its code point, in front of a formatted amount:

    =UNICHAR(8364) & TEXT(B2, "#,##0.00")

    Result"€1,250.00"

  2. A ✅ from its code point for a status column:

    =UNICHAR(9989)

    Result"✅"

UNICHAR in Google Sheets

Same name — your formula ports as-is.

Try UNICHAR in the playground

Edit the example — nothing to install.

Preloaded with the UNICHAR formula from Example 1 — change anything and watch it respond.

Loading the editor…

UNICHAR errors

What they mean — and the fixes.

  • #VALUE!

    The number is 0, negative, or not a valid code point.

Related functions

More ways Excel gets this done.