How to use Excel UNICHAR Function

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”

Leave a Comment