CHAR Function

Converts a number into a character.
Sample Usage
CHAR(126)
Syntax
CHAR(
  • number
)
  • number
    The number to convert into a character.
Usage Notes

This is based on your computer operating system’s character set. You may see different results when using this formula on a different computer.

Examples

CHAR(10) can be used to add a line break within a formula

="Apples" + CHAR(10) + "Oranges"

will display as follows:

Apples
Oranges

NOTE: To display a line break, you must use Wrap Text in that cell. For more information about cell formatting, see Formatting Options.