Explainry Tutorials to Expert in IT

UNICHAR function in Excel


The UNICHAR function returns a Unicode character against a specified number. For example, if you select “36” as the specified number, then the function returns  “$” symbol, which is the Unicode character of the “36” number value.




where the number is a specified numeric value against which the Unicode character is required.

Important Notes

  • The function was first introduced in the 2013 Excel version and categorized under text functions.
  • The function returns #VALUE! error if the number value is supplied “0” or outside the allowable range.

Related Function

UNICODE function returns the Unicode number for the first character of a supplied text string.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved