For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Text Functions

UNICODE

Returns the Unicode number that corresponds to the first character of the text


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

Syntax

UNICODE(text)

  • text  Required. The text for which you want the code of the first character.

Applies To

Excel 2013 and above

Remarks

The Unicode character set is the standard for displaying text on computers in most of the world. ASCII has 255 codes; Unicode has more than 100,000.

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

This figure shows the round trip from a character in column A, to its UNICODE in column B, and then back to the character again in column D.

Example of Excel's UNICODE function

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards