Use the CODE function to determine the numeric code of a character - Text Functions - Microsoft Excel Tutorials

Use the CODE function to determine the numeric code of a character in Microsoft Excel

To return the numeric, or ASCII, code for the first character in a text string, use the CODE function in Microsoft Excel. This function returns the code corresponding to the currently used character set. 

To determine the numeric code of a character:

1. In cells A2:A10, type letters of the alphabet, both uppercase and lowercase.
2. Select cells B2:B10 and type the following formula: =CODE(A2).
3. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=QWWlbHi4CY0