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