Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
UNICODE
UNICODE is the inverse of UNICHAR — it returns the numeric Unicode code point for the first character of a text string. Use it to inspect characters beyond ASCII, validate input encoding, or compare characters across different scripts and symbol sets.
Excel
=UNICODE(A2)Google Sheets
=UNICODE(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Symbol | Code Point |
| A | =UNICODE(A2) |
| Z | =UNICODE(A3) |
| a | =UNICODE(A4) |
| z | =UNICODE(A5) |
=UNICODE(A2)→65
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
- 1Place the text or character you want to inspect in a cell (e.g., '♥' in A2).
- 2Enter =UNICODE(A2) to return 9829, the code point for the heart symbol.
- 3Compare results across cells using UNICODE inside IF or COUNTIF to find or filter specific character types.