CODE function - Microsoft Support (2024)

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2013 More...Less

This article describes the formula syntax and usage of the CODEfunction in Microsoft Excel.

Description

Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.

Operating environment	Character set
Macintosh	Macintosh character set
Windows	ANSI

Syntax

CODE(text)

The CODE function syntax has the following arguments:

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

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Formula	Description	Result
=CODE("A")	Displays the numeric code for A	65
=CODE("!")	Displays the numeric code for !	33

Need more help?

Want more options?

Discover Community



Explore subscription benefits, browse training courses, learn how to secure your device, and more.

FAQs

How to do code function in Excel? ›

The CODE function in Excel is used to find out the character's code in the string. It finds out the code for the first character only, so if we use this formula as =CODE(“Anand”) and =CODE(“An”), we will get the same result as 65 as the code for character A is 65.

Tell Me More ›

What is the code for Microsoft Excel? ›

VBA stands for Visual Basic Analysis. Excel VBA is Microsoft's programming language for Office applications such as MS-Excel, MS-Word, and MS-Access.

How do you get help on a function in Excel? ›

If you're not sure how to use a particular function, you can click the "Help on this function" link at the bottom of the Insert Function dialog box, and that will bring up Excel's Help.

Tell Me More ›

Are Excel functions like coding? ›

From a Coherent perspective, Excel is a programming language simply because it is a way for people define calculations and logic.

Explore More ›

Where do I run code in Excel? ›

Run a macro from the Developer tab

Open the workbook that contains the macro.
On the Developer tab, in the Code group, click Macros.
In the Macro name box, click the macro that you want to run, and press the Run button.
You also have other choices: Options - Add a shortcut key, or a macro description.

Know More ›

What do 37 all formulas in Excel start with? ›

A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula.

Find Out More ›

What are the 25 commonly used formulas in MS Excel? ›

Ajit Yadav 👨🏫 🇮🇳

SUM formula: Example: =SUM(A1:A5) ...
AVERAGE formula: Example: =AVERAGE(B1:B10) ...
COUNT formula: Example: =COUNT(C1:C8) ...
MAX formula: Example: =MAX(D1:D6) ...
MIN formula: Example: =MIN(E1:E4) ...
IF formula: Example: =IF(F1>10, "Pass", "Fail") ...
VLOOKUP formula: ...
CONCATENATE formula:

More items...

Jun 15, 2023

Learn More Now ›

What is the best code to learn for Excel? ›

Coding languages:

VBA: Visual Basic for Application released since 1993.
M language: A script language for PowerBI since 2013.
Office Script: TypeScript integrated into MS Office since 2019 (if I remember correctly)
Python: Integrated into MS Office just recently.

Oct 11, 2023

What is the formula code? ›

Formula code is a collection of whitespace, identifiers, keywords, literals, comments, operators and separators.

Read The Full Story ›

How many lines of code does Excel have? ›

Originally Answered: Did it really take millions lines of code to write Excel? Yes, Excel is definitely >1 million lines, probably multiple millions.

Show Me More ›

What is the most useful Excel function and why? ›

VLOOKUP. The VLOOKUP function is one of the most commonly used and recognizable functions in Excel. It will look for a value in a table and return information from another column relating to that value.

Get More Info ›

What are common functions of Microsoft Excel? ›

IF Function. The Excel IF function is the most essential function in Excel for logical tests. ...
MIN & MAX Function. The Excel MIN function returns the smallest numeric value in a range of values. ...
TRIM Function. ...
CONCATENATE Function. ...
COUNT Function. ...
COUNTA Function. ...
COUNTIF Function. ...
SUMIF Function.

Discover More Details ›

What are the 10 basic Excel formulas? ›

IF Function. The Excel IF function is the most essential function in Excel for logical tests. ...
MIN & MAX Function. The Excel MIN function returns the smallest numeric value in a range of values. ...
TRIM Function. ...
CONCATENATE Function. ...
COUNT Function. ...
COUNTA Function. ...
COUNTIF Function. ...
SUMIF Function.

How do you use Excel formulas for beginners? ›

Enter a formula that contains a built-in function

Select an empty cell.
Type an equal sign = and then type a function. For example, =SUM for getting the total sales.
Type an opening parenthesis (.
Select the range of cells, and then type a closing parenthesis).
Press Enter to get the result.

Find Out More ›

How do I get a list of formulas in Excel? ›

1. Show Formulas option on the Excel ribbon. In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away.

What is the most popular formula in Excel? ›

1. SUM. The SUM function in Excel is used to add up the numbers in a range of cells. It's one of the most popular functions and is quite easy to use.

View Details ›