Retrieve characters from numbers.

`=CHAR(number)`

- number - a number between 1 and 255 (required)

`=CHAR(65)`

The CHAR function can be used to return a character based on an ASCII or ANSI value. For example, the formula above returns the character "A". It is especially useful when you need to include a character in a formula or text string that is not easy to type.

`=CHAR(10)`

The CHAR function can also be used to add line breaks in a formula. The formula above adds a line break in a formula

The CHAR function is used to convert numerical code page numbers into characters. It is used to translate numerical code page numbers from other computers.

- The CHAR function takes one argument and returns a character string. The argument should be an integer between 0 and 255 to return a text value.
- The CHAR function was designed to work in an ASCII/ANSI world and only understands numbers 0-255.
- The CHAR function takes text wrap into account.
- The CHAR function throws a #VALUE! error if the number is out of range or not a number.

The CHIDIST function calculates the one-tailed probability of the chi-squared distribution.

The chi-squared distribution is used in a Î³2 test, which compares observed and expected values.

- The #VALUE! error is thrown if either argument is not numerical.
- The #NUM! error is thrown if x is negative.
- The degrees_freedom argument is truncated if it is not an integer.