Text
Excel 2013
◉ 39 views
=UNICHAR()
Returns the Unicode character that is referenced by the given numeric value.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=UNICHAR(number)
Hover argument names in the table for details.
Output typeText
Popularity20 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =UNICHAR() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | Number is the Unicode number that represents the character. |
▣ Examples
Returns the character represented by the unicode number 66 (uppercase B).
=UNICHAR(66)
Result:
B
Returns the character represented by the unicode number 32 (space character).
=UNICHAR(32)
Result:
Space character
The unicode number 0 returns the error value #VALUE!
=UNICHAR(0)
Result:
#VALUE!
§ Remarks
- The Unicode character that is returned can be a string of characters, for example in UTF-8 or UTF-16 codes.
- If Unicode numbers are partial surrogates and data types that are not valid, UNICHAR returns the #N/A error value.
- If numbers are numeric values that fall outside the allowable range, UNICHAR returns the #VALUE! error value.
- If number is zero (0), UNICHAR returns the #VALUE! error value.
✦ Tips
- The Unicode character that is returned can be a string of characters, for example in UTF-8 or UTF-16 codes.
⚠ Common Errors
#N/A
If Unicode numbers are partial surrogates and data types that are not valid, UNICHAR returns the #N/A error value.
Fix: کد یونیکد معتبر وارد کنید؛ از مقادیر جانشین ناقص استفاده نکنید.
#VALUE!
If numbers are numeric values that fall outside the allowable range, UNICHAR returns the #VALUE! error value. If number is zero (0), UNICHAR returns the #VALUE! error value.
Fix: Check the Unicode code
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!