Documentation/Calc Functions/CHAR

Function name:
CHAR

Category:
Text

Summary:
Determines the character that corresponds to a given code point in the current coded character set. In some cases, the character returned by CHAR may be a non-printing character that is not readily visible (for example control characters).

The CHAR function is complementary to the CODE function.

For some code points, CHAR may return the same character as the UNICHAR function but for other code points the character returned may be system-specific and different.

Syntax:
CHAR(Number)

Returns:
Returns the single character that corresponds to the given code point in the current coded character set.

Arguments:
Number is an integer in the range 0 ≤ n ≤ 255, or a reference to a cell containing such an integer, that is the code point of the character that is required.


 * If Number is non-numeric, then CHAR reports a #VALUE! error.
 * For a non-integer value of Number, CHAR truncates the value to an integer.
 * If, after any truncation, Number is less than 0 or greater than 255, then CHAR reports an invalid argument error (Err:502).

Additional details:
For any code point n,

Since the characters returned for some code points can differ between systems, spreadsheets using the CHAR function may not be portable.

Related LibreOffice functions:
CODE

UNICHAR

UNICODE

ODF standard:
Section 6.20.3, part 2

Equivalent Excel functions:
CHAR