Calc CHAR function

The CHAR function is used to translate numerical codes into characters, based on the computer's character set.

Help Centre › Functions & Formulas

For a full list of available calculation functions, please read What calculation functions are supported.


Description

The CHAR function is used to translate numerical codes into characters.


Syntax

CHAR(number)


The CHAR function syntax has the following arguments:

  • Number Required. This is a numeric value, and you need to specify a number between 1 and 255.

Example

FormulaDescriptionResult
=CHAR(65)Displays the character represented by 65 in the computer's character set.A
=CHAR(33)Displays the character represented by 33 in the computer's character set.!

Errors

For a full list of formula errors, please read Formula errors.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.

Get started Start a 7-Day Proof-of-Value