Excel’s CHAR function returns a character based on the ASCII code. It is a simple yet useful function.
Syntax
CHAR(number)
Arguments
number | The ASCII code of the character you want to retrieve. Must be a number between 1 and 255. |
How to use
Here are some examples of how to use the CHAR function:
1 |
=CHAR(65) |
1 |
=CHAR(97) |
1 |
=CHAR(33) |
1 |
=CHAR(176) |
Remember that the number must be between 1 and 255, as it corresponds to valid ASCII codes.