How to use Excel UNICODE Function


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.




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


  • 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.


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 Comment

Your email address will not be published. Required fields are marked *