Statistical - UNICHAR Function

Description

The UNICHAR function returns the Unicode character that is referenced by the given numeric value.

Syntax

UNICHAR (number)

Arguments

Argument Description Required/ Optional
Number Number is the Unicode number that represents the character. Required

Notes

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

  • If number is not recognized as a numeric value, UNICHAR returns the #VALUE! error value.

Applicability

Excel 2013, Excel 2016

Example

UNICHAR Function
advanced_excel_statistical_functions.htm
Advertisements