CHAR

The CHAR function returns a character when given a valid character code. Use the CHAR to translate ASCII code page numbers into actual characters. For example: the CHAR function takes just one argument, number, which must be an integer between 0-255. The result from CHAR is a text value. The CHAR function was designed to operate in an ASCII/ANSI world and only understands numbers 0-255. For extended character support on modern Unicode systems, see the UNICHAR function. CHAR can be useful when you want to specify characters in formulas or functions that are awkward or impossible to type directly. For example, you can use CHAR(10) to add a line break in a formula like this: Notes: Text wrap must be enabled to see the line break take effect. Older versions of Excel on the Mac use character 13