Excel UNICODE Function

Basic Description

The Excel Unicode function returns the code point for the the first character of a supplied text string.

Note: The Unicode function is new in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

UNICODE( text )

Where the text argument is a text string beginning with the character you require the code point for.


Unicode Function Examples

The following spreadsheet shows the Excel Unicode function, used to return the numeric code point for four different characters.

 Formulas:
 A
1=UNICODE( "Alpha" )
2=UNICODE( "alpha" )
3=UNICODE( "?" )
4=UNICODE( "3" )
 Results:
 A 
165  - returns the code point for the character "A"
297  - returns the code point for the character "a"
363
451

For further information and examples of the Excel Unicode Function, see the Microsoft Office website.