Related Functions:

The UNICODE function returns the number (code point) corresponding to the first character of the text.

  • This function is new in Excel 2013 and so is not available in earlier versions of Excel.

Syntax

=UNICODE(text)

Arguments

Argument Description
text The character for which you want the Unicode value

Examples

  A B C
1 Formula Result Notes
2 =UNICODE(” “) 32 Returns the unicode number that the space character (a single space inside quotation marks) represents (32).
3 =UNICODE(“B”) 66 Returns the unicode number that the uppercase “B” represents (66).

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if text contains partial surrogates or data types that are not valid