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