CHAR Function – Explained with Examples

CHAR returns the graphical representation of the ANSI/ASCII Extended character set or Macintosh Character Set as available on your computer.

Function Syntax

=CHAR(number)
  • a numeric value 0-255

Usage

Users wanting to refer to the ANSI/Mac character set can use CHAR to return the graphical representation where available from input values 0-255.

Also values can be compared to the CHAR representation for onward processing. A typical use might be to enable text parsing, or cleaning of data, when combined with other functions such as SUBSTITUTE.

Example of the ANSI/ASCII Extended Latin-1 character set available on Excel.

ANSI ASCII Extended character set (codes 0-127 only) returned by the Excel CHAR function
ANSI ASCII Extended character set (codes 128-255 only) returned by the Excel CHAR function

Examples

Related Topics

F007