Navigation:  Formula Reference > Spreadsheet Formula Functions >

CHAR

Previous pageReturn to chapter overviewNext page

 

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 Ú

 

See Also

CODE

CONCATENATE

LOWER

PROPER

UPPER