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 )


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


Example of CHAR Function in Excel:


CHAR Function in Excel 1


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

DataScience Made Simple