How to use UNICHAR Function in Excel

The Excel UNICHAR function returns a Unicode character based on a given number.

Syntax:= UNICHAR (number)

The UNICHAR function syntax has the following arguments:

  • Number    Required. Number is the Unicode number that represents the character.

Example: Let’s look at some Excel UNICHAR function examples and explore how to use the UNICHAR function as a worksheet function in Microsoft Excel:

UNICHAR Function - How to use UNICHAR Function in Excel

Syntax:  =UNICHAR(A2)

Result:

UNICHAR Function in Excel - How to use UNICHAR Function in Excel

Based on the Excel spreadsheet above, the following UNICHAR examples would return:

Syntax: =UNICHAR(A3)
Result: h

Syntax: =UNICHAR(A4)
Result: ^

Syntax: =UNICHAR(A5)
Result: $

Syntax: =UNICHAR(A6)
Result:

Syntax: =UNICHAR(A7)
Result: 🙂

Syntax: =UNICHAR(A8)
Result:

Syntax: =UNICHAR(A9)
Result: ©

Syntax: =UNICHAR(A10)
Result: ¥

Syntax: =UNICHAR(A11)
Result:

Syntax: =UNICHAR(A12)
Result: µ

Syntax: =UNICHAR(A13)
Result: ®

Syntax: =UNICHAR(A14)
Result: Space character

Note:

  • The Unicode character that is returned can be a string of characters, for example in UTF-8 or UTF-16 codes.
  • If Unicode numbers are partial surrogates and data types that are not valid, UNICHAR returns the #N/A error value.
  • If numbers are numeric values that fall outside the allowable range, UNICHAR returns the #VALUE! error value.
  • If number is zero (0), UNICHAR returns the #VALUE! error value.

READ:  How to use UNICODE Function in Excel

Add a Comment

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