Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
UNICHAR
UNICHAR extends CHAR beyond the 255-character ASCII limit by accepting any Unicode code point and returning the corresponding character. It is useful for inserting emoji, arrows, currency symbols, Greek letters, or any other Unicode character using its numeric code point.
Excel
=UNICHAR(9829)Google Sheets
=UNICHAR(9829)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Code | Symbol |
| 9829 | =UNICHAR(9829) |
| 9830 | =UNICHAR(9830) |
| 8594 | =UNICHAR(8594) |
| 9733 | =UNICHAR(9733) |
=UNICHAR(9829)→♥
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Look up the Unicode code point for the character you need — for example, 9829 for a heart symbol (♥) or 8594 for a right arrow (→).
- 2Enter =UNICHAR(9829) to output '♥' in the cell.
- 3Use UNICHAR inside a concatenation formula such as =A2&" "&UNICHAR(8594)&" "&B2 to add an arrow between two text values.
Need a version for your data?
Try: “Insert a checkmark or special Unicode symbol into spreadsheet cells”