How to use Excel UNICODE Function

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:

UNICODE function example file Download