Syntax
UNICHAR(number)
| Parameter | Description |
|---|---|
| number | Parameter of the UNICHAR function. |
Examples
Euro sign
Formula
=UNICHAR(8364)
Returns the Euro symbol (€). Useful when building formatted currency strings.
Checkmark symbol
Formula
=IF(A1="Done", UNICHAR(10003), "")
Displays a checkmark (✓) for completed items and leaves the cell blank otherwise.
Degree symbol
Formula
=A1 & UNICHAR(176) & "C"
If A1=37, returns "37°C". Appends the degree symbol for temperature display.
Common Errors
#VALUE!
Occurs when the code point is invalid (0, negative, or above 1114111) or corresponds to a non-character code point.
#N/A
Some implementations return #N/A for surrogate code points (55296-57343) which are not valid standalone characters.
Tips
Common useful code points
8364=€, 163=£, 165=¥, 176=°, 10003=✓, 10007=✗, 9733=★, 9829=♥. Look up code points at unicode-table.com.
UNICHAR vs CHAR
CHAR only handles codes 1-255 (extended ASCII). UNICHAR handles the full Unicode range up to 1,114,111. Use UNICHAR for any non-ASCII symbol.
Reverse with UNICODE
UNICODE("€") returns 8364. Use this pair to analyze and generate characters programmatically.
Try UNICHAR in Viztab
Import your data and use UNICHAR with 370+ other formulas. No signup required.
Open Viztab