CHAR
Formulas / CHARRetrieve characters from numbers.
=CHAR(number)
- number - a number between 1 and 255 (required)
Examples
=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
Summary
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.
Frequently Asked Questions
What is the CHIDIST function?
The CHIDIST function calculates the one-tailed probability of the chi-squared distribution.
What is the chi-squared distribution used for?
The chi-squared distribution is used in a γ2 test, which compares observed and expected values.
What errors are thrown by the CHIDIST function?
- 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.
