Advanced Excel Statistical - CHAR Function

Description

The CHAR function returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.

Syntax

CHAR (number)

Arguments

Argument	Description	Required/ Optional
Number	A number between 1 and 255 specifying which character you want. The character is from the ANSI character set for Windows environment.	Required

Argument

Description

Required/ Optional

Number

A number between 1 and 255 specifying which character you want.

The character is from the ANSI character set for Windows environment.

Required

Notes

If number is not recognized as a numeric value or is a number outside of the permitted range 1 to 255, CHAR returns #VALUE! Error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm