CHAR

The CHAR function returns the character that corresponds to a decimal Unicode character code.

CHAR(code-number)

code-number: A number value for which you want to return the corresponding Unicode character. code-number must be greater than or equal to 32 and less than or equal to 65,535, not equal to a control character (127-159), and not an illegal character.

Notes

Any decimal portion is ignored.
Not all Unicode numbers are associated with a printable character.
Character 32 is the space character.
The CODE function returns the numeric code for a specific character.

Examples
=CHAR(98.6) returns “b”, which is represented by the code 98. The decimal portion of the number is ignored. =CODE(“b”) returns 98.

Examples

=CHAR(98.6) returns “b”, which is represented by the code 98. The decimal portion of the number is ignored.

=CODE(“b”) returns 98.