Spread Formula Reference
CHAR
Formula Functions > Functions A to C > CHAR

This function returns the character specified by a number.

Syntax

CHAR(value)

Arguments

For the argument, use a number between 1 and 255 specifying which character you want from the Windows character set (ANSI).

Data Types

Accepts numeric data. Returns string data.

Examples

CHAR(B2)

CHAR(R2C2)

CHAR(66) gives the result B

CHAR(218) gives the result Ú

Version Available

This function is available in product version 1.0 or later.

See Also

CODE | CONCATENATE | LOWER | PROPER | UPPER | Text Functions