Excel UNICODE Function

Function Description

The Excel Unicode function returns the code point for 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

See the Microsoft Office website for further information and examples of the Excel Unicode Function.