Documentation/Calc Functions/CHAR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

CHAR

Category:

Text

Summary:

Converts a number into a character according to the current code table. The number can be a two-digit or three-digit integer number.

Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.

Syntax:

CHAR(Number)

Returns:

Arguments:

Number is a number between 1 and 255 representing the code value for the character.

Additional details:

Examples:

=CHAR(100) returns the character d.

="abc" & CHAR(10) & "def" inserts a newline character into the string.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: