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 | ||
|---|---|---|---|
| 1 | Unicode value | Description | |
| 2 | 65 | Capital A | |
| 3 | 9786 | White Smiling Face | |
| 4 | 8364 | Euro Sign | |
| 5 | 937 | Greek Capital Letter Omega |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Turn a Unicode number into its corresponding character. | =UNICHAR(A2) |
Converts the value 65 into the character it represents. Result: A |
| Insert a special symbol, like a smiley face, using its Unicode number instead of typing the symbol directly. | =UNICHAR(A3) |
Converts the value 9786 into its corresponding symbol. Result: ☺ |
| Insert a currency symbol using its Unicode number instead of typing the symbol directly. | =UNICHAR(A4) |
Converts the value 8364 into its corresponding symbol. Result: € |
| Combine two Unicode numbers with math, then convert the result into a character. | =UNICHAR(A2+A5) |
Adds 65 and 937 to get 1002, then converts that combined value into its corresponding character. Result: Ϫ |
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.