UNICHAR

Formulas / UNICHAR
Return 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 ‘!’

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV