Formulas / UNICHAR
Return the Unicode character corresponding to a given number.
  • number - required, an integer number or a cell reference to a worksheet with a number


  • =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.


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 ‘!’

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.