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

Text Functions


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



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

Applies To

Excel 2013 and above


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.


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