Introduction
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.
Syntax
=UNICHAR( Number)
Arguments
Number: It is the number which will be used to find the Unicode character
Keynotes
- 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.
Examples
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”