The Excel UNICHAR function is a Text formula that returns the Unicode character of a given numeric code. This function comes in handy when you need to insert special characters that are typically not found on a standard keyboard layout. In this guide, we’re going to show you how to use the UNICHAR function and also go over some tips and error handling methods.
Supported versions
- All Excel versions
UNICHAR Function Syntax
UNICHAR(number)
Arguments
number | The number that represents the Unicode character. |
Examples
The UNICHAR function is very easy as it requires a single argument as an input. You only need to enter the numeric code for the corresponding Unicode character. For example, to return a capital letter "A", use 65 as the number argument.
Of course, you can retrieve characters up to 255 using the CHAR function as well. The UNICODE function is especially useful for inserting characters from the ASCII character set. For example, symbols like Ω, √ or emoji, 🙂, 🙌 can be added with the help of this function.
Tips
- You can see a list of available Unicode characters from here.
- Unicode contains ASCII character set. The numeric codes are the same for both.
- You can use the UNICODE function to get the numeric code of the Unicode character used as an input for this function.
Issues
- The UNICHAR function returns the #VALUE error for input numbers outside the Unicode character range. For example, 0 or negative numbers.
- If the number is an invalid character, the function returns #N/A
- Non-string characters, except a few (like a new line) will be displayed empty ( ).