Formulas and Functions
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. |
See alsoCODE