Tuesday, September 19, 2017

CHAR function

CHAR function

Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.

Syntax

CHAR(number)

Number is a number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.

Examples

Formula

Description (Result)

=CHAR(65)

Displays the 65 character in the set (A)

=CHAR(33)

Displays the 33 character in the set (!)

No comments:

Post a Comment