CHAR

Returns the character represented by given number.

Syntax

=CHAR(Number, [CharacterSet])

Arguments

Name

Description

Number

A number between 1 and 255 which specifies the character to return.

CharacterSet

Optional. A string which specifies the character set to use for converting the number. Following two sets are currently supported: ‘ansi’ alias ‘cp1252’ and ‘mac’ alias ‘roman’. If no character-set is specified ‘ansi’ is used by default.

Return Value

The character as specified by given number.

Example

Function

Result

=CHAR(65)

A

=CHAR(128)

=CHAR(128, “ansi”)

=CHAR(128, “mac”)

Ä