Formulas / CHAR
Retrieve characters from numbers.
  • 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.

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.

Get smart about your data.

Connect, sync, and query data from 37+ data sources, without code.
Get unlimited access free for 14 days.