# CODE Function

## Description

The CODE function returns a numeric code for the first character in a text string.

If you want to return the character specified by the code number, please use CHAR Function.

CODE(text)

## Parameters

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

## Examples

### Example 1

The example may be easier to understand if you copy A1:C5 to a blank worksheet.

1
2
3
4
5
A B C
Formula Result Description
=CODE("Apple") 65 Displays the numeric code for Apple (the first character, 65)
=CODE("A") 65 Displays the numeric code for A (65).
=CODE("a") 97 Displays the numeric code for a (97)
=CODE("℃") 64 Displays the numeric code for ℃ (41446)

If you remember the code of a symbol, you can fast input it with follow tip:

For example: you know the code of ℃ is 41446 (CODE("℃")=41446), hold down the ALT key, type 4 1 4 4 6 on the number pad, then releasing ALT, it will enter ℃ symbol.

### Example 2: Data validation - check for alphabetic characters only

If cell A1 contains a text string, the below formula will check it is all alphabetic characters:

`=AND(N(CODE(RIGHT(UPPER(A1),ROW(INDIRECT("1:"&LEN(A1)))))>{64,90})={1,0})`

Note that this is a array formula, please end this formula with CTRL SHIFT ENTER.

## Video training

ASC
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
BAHTTEXT
Converts a number to text, using the ß (baht) currency format
CHAR
Returns the character specified by the code number
CLEAN
Removes all nonprintable characters from text
CODE
Returns a numeric code for the first character in a text string
CONCATENATE
Joins several text items into one text item
DOLLAR
Converts a number to text, using the \$ (dollar) currency format
EXACT
Checks to see if two text values are identical
FIND, FINDB
Finds one text value within another (case-sensitive)
FIXED
Formats a number as text with a fixed number of decimals
WIDECHAR
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
LEFT, LEFTB
Returns the leftmost characters from a text value
LEN, LENB
Returns the number of characters in a text string
LOWER
Converts text to lowercase
MID, MIDB
Returns a specific number of characters from a text string starting at the position you specify
PHONETIC
Extracts the phonetic (furigana) characters from a text string
PROPER
Capitalizes the first letter in each word of a text value
REPLACE, REPLACEB
Replaces characters within text
REPT
Repeats text a given number of times
RIGHT, RIGHTB
Returns the rightmost characters from a text value
SEARCH, SEARCHB
Finds one text value within another (not case-sensitive)
SUBSTITUTE
Substitutes new text for old text in a text string
T
Converts its arguments to text
TEXT
Formats a number and converts it to text
TRIM
Removes spaces from text
UPPER
Converts text to uppercase
VALUE
Converts a text argument to a number