CHAR

Formulas / CHAR
Retrieve 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.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV