Using the Excel CHAR Function
SummaryThe 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.
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 NotesThe 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: