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->.
USE THE CODE FUNCTION TO DETERMINE THE NUMERIC CODE OF A CHARACTER USING MICROSOFT EXCEL |
No comments:
Post a Comment