Introduction
UNICODE function are text/string function in excel. This function is used to find out number corresponding to a Unicode character. Unicode is in form of decimal numbers from 0 to 65535. It retrieves number of first character of a text string. This function was introduced in Excel 2013 and later versions. It is a worksheet function and can be entered in the cell of a worksheet.
Syntax
=UNICODE( Text)
Arguments
Text: It is the text string or a single character corresponding to which number will be found. It can also be a cell reference containing the text
Keynote
- If numbers used are partial and invalid data types are used than #VALUE error is displayed.
- If number is zero or greater than the specified range #VALUE error is displayed.
- It is case sensitive and gives different results for uppercase and lowercase letters.
- This function is opposite to the UNICHAR function.
Examples
In this example, some characters are entered in column A an UNICODE function is used to retrieve their corresponding Unicode numbers as follows:
