CHAR FUNCTION IN EXCEL – Return Character based on ASCII value

CHAR Function in Excel returns the Character for the corresponding ASCII Value. CHAR Function takes up the number (ranging from 1 to 255) as an input and matches with the ASCII value and returns the corresponding character.

Syntax of CHAR Function in Excel:

CHAR( number )

Where,

number – number argument which is an integer ranging from 1 to 255.

Example of CHAR Function in Excel:

Formula

Result

CHAR Function in Excel 2

Note: #VALUE! Error occurs

if the supplied argument cannot be interpreted as a numeric value in excel
The supplied number argument is not in the range between 1 and 255