Fresh Excel Tips

In this article, we will learn how to return the numeric, or ASCII, code for the first character in a text string by using the CODE function in Excel. What this function does is that it returns the code corresponding to the currently used character set. Here is how we’ll apply it in our formula:

How to determine the ASCII code of a character in Excel

1. In cells A1:A10, type letters of the alphabet, both uppercase and lowercase.
2. Select cells B1:B10 and type the following formula: =CODE(A1).
3. Press CTRL+Enter.

You should now see the ASCII codes in Column B corresponding to the letters. This tip should work in Excel 97, 2000, 2003 and 2007.

1. VBA Commenting and Line Continuation
2. Using the PROPER function to change first letters to uppercase
3. Use the ISODD and COLUMN functions to determine odd columns
4. How to remove word wrapping in cells using Excel
5. How to Use the ISODD and ROW functions to determine odd rows