Buzz
The UNICHAR() and UNICODE() functions are utilized for UNICODE character encoding. You can retrieve a Unicode character from a numerical value using the UNICHAR() function and vice versa obtain the numerical value from a Unicode character with the UNICODE() function.
This article describes the syntax and usage of the UNICHAR() and UNICODE() functions in Excel.
UNICHAR Function
Description
The UNICHAR() function returns the Unicode character of the input numerical value and is used for UNICODE character encoding.
Syntax
=UNICHAR(number)
In which:
number represents the numeric character to be converted into a Unicode character, it is a mandatory parameter.
Note
- The returned Unicode character can be a string of characters (such as UTF-8, UTF-16 encoding).
- If number is 0 (zero) or values outside the allowed range, the UNICHAR function returns the #VALUE! error.
- If number represents a partial surrogate and invalid data types, the function will return the #N/A error.
Example
=UNICHAR(78)
Hàm UNICODE
Description
The UNICODE() function returns the number of the input character. If the input is a string, the function returns the number of the first character in the string. Used for Unicode encoding.
Syntax
=UNICODE(text)
In which:
text is the character or string of characters from which to obtain the Unicode value. If text contains invalid data types, the function returns an error #VALUE!.
Example
=UNICODE('A')
=UNICODE('Mytour')
Using both UNICHAR() and UNICODE() functions is straightforward. However, these functions are supported only in Excel 2013. For Excel 2003, 2007, and 2010, they are not supported. You may need to install Office 2013 to utilize these functions. Wish you success!
