UNICHAR
Formulas / UNICHARReturn the Unicode character corresponding to a given number.
UNICHAR(number)
- number - required, an integer number or a cell reference to a worksheet with a number
Examples
=UNICHAR(66)The UNICHAR function can be used to return a character. It takes a single argument, the numerical code of the character that you wish to return. For example, the example will return the uppercase B character.
=UNICHAR(32)The UNICHAR function can also be used to return whitespace characters. For instance, this formula will return the space character.
Summary
The UNICHAR function is a useful tool that returns the Unicode character referenced by a numeric value. It requires a single numeric argument and will return a #VALUE! error if given a zero argument.
- The UNICHAR function requires a number as an argument and returns the corresponding Unicode character.
- The number argument must be the code point of a Unicode character.
- The UNICHAR function returns a #VALUE! error if the number argument is not a recognized number or it is out of range.
Frequently Asked Questions
What is the UNICHAR function?
The UNICHAR function returns the Unicode character referenced by a numeric value.
What is the syntax of the UNICHAR function?
The syntax of the UNICHAR function is UNICHAR(numeric_argument). The numeric argument is required.
What happens if the argument passed to the UNICHAR function is zero?
If the argument passed to the UNICHAR function is zero, the function returns a #VALUE! error.
What are some examples of using the UNICHAR function?
- UNICHAR(65) returns the character ‘A’
- UNICHAR(97) returns the character ‘a’
- UNICHAR(32) returns the character ‘ ‘ (space)
- UNICHAR(33) returns the character ‘!’
