UNICHAR

Formula Explanation

Returns the Unicode character referenced by the given numeric reference.

Formula Syntax

Enter in the result column: UNICHAR(number / column number)

The UNICHAR function syntax has the following argument:

• The returned Unicode character can be a string, such as a string encoded in UTF-8 or UTF-16.

• If the Unicode number is a surrogate and the data type is invalid, UNICHAR returns the error value #N/A.

• If the number's value exceeds the allowed range, UNICHAR returns the error value #VALUE!.

• If the number is zero (0), UNICHAR returns the error value #VALUE!.

Usage Example

Return the Unicode character for the value in column EU2 and write the result in column EU3.

EU3 = UNICHAR(EU2)

✉️ Ask Tablize