CHAR

Using the Excel CHAR Function

Summary

The Excel CHAR function will return a character specified by a number. This function is handy if you need to translate page numbers from files on other types of computer into characters.

The character set will depend on the operating system of your machine. If you are on a Windows OS, the ANSI character set is used. This system consists of 218 characters. Learn more about ANSI. If you are on a Macintosh OS, the Macintosh character set is used.


Syntax

=CHAR (number)

Syntax Breakdown

Number
Required. An integer between 1 and 255 that specifies which character you want. The character set used by your computer will determine the output. As mentioned above, Windows machines use ANSI and Macintosh machines use the Macintosh character set.


Usage Notes

The CHAR function is useful when specifying characters in formulas and functions that would be difficult, if not impossible, to enter directly. For example, =CHAR(10) adds a line break on Windows machines. Use =CHAR(13) for a line break on a Macintosh device.

For a complete list of characters and the values they return, see the following resources:

Windows: https://en.wikipedia.org/wiki/Windows-1252

Macintosh: https://en.wikipedia.org/wiki/Mac_OS_Roman