Spread 8.0 Documentation
CHAR
Support Options
Formula Reference > Built-In Functions > CHAR

Glossary Item Box

CHAR


Name

Character

Description

Returns the character specified by a number.

Syntax

CHAR(value)

Remarks

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

See also LEFT, LOWER, MID, PROPER, RIGHT, and UPPER.

Data Type

Accepts numeric data. Returns string data. For more information, see Data Type for Each Cell Type.

Example

CHAR(B2)
CHAR(66)=B
CHAR(218)=Ú

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.