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:

Leave a Reply

Close Menu
×

Cart