CODE

Returns the numeric Unicode code value of the first character in a text string.

Syntax

CODE(text)

Arguments

Argument	Description	Required
text	The text whose first character's code you want to obtain	Required

Examples

Get code of uppercase letter

Get code of first character in string

Get code of special character

Related Functions

Other Text functions:

• CHAR - Converts a number into a character according to the current Unicode table.
• CLEAN - Removes all nonprintable characters from text
• CONCATENATE - Returns the concatenation of a list of arguments.
• ENDSWITH - Returns TRUE if the text ends with search text, returns FALSE otherwise.
• EXACT - Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise
• FIND - Returns the position of the first occurrence from within_text.
• FIXED - Formats a number as text with a fixed number of decimals
• JOIN - Returns the combination of two or more one-dimensional arrays, separated by delimiter.
• LEFT - Returns a substring from the left side of a supplied string.
• LEN - Returns the length of a given string.
• LOWER - Returns a string after converting it to lowercase
• MID - Returns a substring from the middle of a given string.
• PROPER - Capitalizes the first letter in each word of a text value
• REGEXMATCH - Returns true if the text matches the regular expression pattern; otherwise returns false.
• REPLACE - Replaces part of a text string with a different text string
• REPT - Repeats text a given number of times
• RIGHT - Returns a substring from the right side of a given string.
• SEARCH - Returns the start position of the find_text string from the first character of the text string.
• SPLIT - Divides text around a specified character or string and returns the parts in a single-row array.
• STARTSWITH - Returns TRUE if the text starts with search text, returns FALSE otherwise.
• SUBSTITUTE - Returns the text after replacing one or more text strings with another text string
• TEXTJOIN - Returns the combination of two or more one-dimensional arrays with or without a delimiter.
• TRIM - Removes all spaces from a text string except for single spaces between words.
• UPPER - Returns the string after converting all letters to uppercase
• VALUE - Returns a numeric value for a text that appears in a recognized format (i.e. a number, date, or time format).

---

← Back to Formula Reference