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.