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

CHAR Function in Excel 1

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

previous CHAR FUNCTION IN EXCEL                                                                                                           next CHAR FUNCTION IN EXCEL