How to use Excel UNICHAR Function


UNICHAR function are text/string function in excel. This function is used to find out Unicode character of a defined number. Unicode is in form of decimal numbers from 0 to 65535.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.


=UNICHAR( Number)


Number: It is the number which will be used to find the Unicode character


  • Unicode character retrieved may also be a string of characters based on the initial number.
  • If numbers used are partial and invalid data types are used than #N/A 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.


In this example, some numbers are entered in column A an UNICHAR function is used to retrieve their corresponding Unicode characters as follows:

Unicode Number Result
80 P
113 q
67 C
91 [
165 ¥

1 thought on “How to use Excel UNICHAR Function”

  1. Pingback: How to use Excel UNICODE Function - Excelhub

Leave a Comment

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