Skip to content
Google Sheets

UNICHAR function in Google Sheets

Returns the Unicode character for a number. .

=UNICHAR(number)

UNICHAR syntax and parameters

One argument, one required.

  • numbernumberRequired

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 Excel

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 Google Sheets gets this done.