Description
Use this function to return the Unicode character that is referenced by the given numeric value. This is the opposite of the UNICODE function. UNICHAR can be useful for inserting special characters into text strings without having to type them directly.
Syntax
UNICHAR(number)
Inputs
This function accepts the following argument:
| Name | Required | Description | Valid input |
|---|---|---|---|
number |
Yes | The Unicode number representing a character. | An integer in the range from 1 to 1114111 (0x10FFFF in hexadecimal) inclusive. |
Example
Sample data
| A | B |
|---|---|
| Unicode | Description |
| 65 | Capital A |
| 9786 | White Smiling Face |
| 8364 | Euro Sign |
| 937 | Greek Capital Letter Omega |
Sample formulas
| Formula | Description | Result |
|---|---|---|
=UNICHAR(A2) |
Returns the character for Unicode 65 | A |
=UNICHAR(A3) |
Returns the character for Unicode 9786 | ☺ |
=UNICHAR(A4) |
Returns the character for Unicode 8364 | € |
=UNICHAR(A2+A5) |
Returns the character for Unicode 1002 | Ϫ |
Notes
- If the text string is empty, zero, or outside the allowable range of 1 to 1,114,109, UNICHAR returns the #VALUE! error.
- Some Unicode characters, such as control characters, may not display properly in Workiva cells.
- The font used in a worksheet may alter the appearance of characters, especially for 'high ASCII' characters (characters numbered 128 to 255, corresponding to Unicode U+0080 to U+00FF). Different fonts may render these characters in various ways, which might affect their visual representation.
- UNICHAR is particularly useful when working with international text or special symbols.
- The number argument can be a decimal or hexadecimal number. For example, to get the Unicode character for the letter "A", which corresponds to the number 65, the formula would be: =UNICHAR(65).
Tips
- Use UNICHAR in combination with UNICODE to convert between characters and their numeric representations.
- Remember that some Unicode characters, such as emojis or certain symbols, may not display correctly in all language sets or on all devices.
Related functions
CHAR
CODE
CONCATENATE
CONCATENATEIF
FIND
LEFT
LEN
LOWER
MID
PROPER
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER