Help Center

CHAR

Formula Explanation

Returns the character corresponding to a numeric code. CHAR is used to convert code page numbers obtained from files on other types of computers into characters.

  • Macintosh: Macintosh character set

  • Windows: ANSI character set, which is the standard character set used in the Windows operating system prior to Windows 95 and Windows NT, which adopted Unicode. ANSI includes 218 characters, many of which share the same numeric codes as ASCII/Unicode formats.

Referopen in new window

Formula Syntax

Enter in the result column: CHAR(number / column_number)

The CHAR function syntax has the following arguments:

  • Number: A number between 1 and 255 that specifies the character you want. The character is from the character set of the current computer.

Note: In Excel Online, only CHAR(9), CHAR(10), CHAR(13), CHAR(32), and higher values are supported.

Usage Examples

  1. Display the characters corresponding to the values in column BT2 according to the computer's character set, and write the results into column BT3.
BT3 = CHAR(BT2)

char_col

  1. Display in column BU2 the character represented by 33 in the computer's character set.
BU2 = CHAR(33)

char_value

Last Updated: