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
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
