Excel Formulas to Convert column letter to number in excel!!

Before entering into this article, you should know what is the column in Excel? It is nothing but the vertical series of cells in an Excel sheet. Here, I will talk about how to convert the column letter to number in Excel by using the formula. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• To convert the column letter to number, you can use the below formula.

=[COLUMN](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)([INDIRECT](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)(letter&"1"))

Syntax Explanation

• COLUMN ** – The **COLUMN Function in Excel returns the column number for a reference.
• INDIRECT – The INDIRECT Function in Excel returns a valid reference from a given text string.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Examples

Refer to the below example image.

• For instance, you have to create a sample data in Excel.

Sample data

• To convert the column letter to number, you need to use the following formula in formula bar.

=[COLUMN](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)([INDIRECT](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)(B5&"1"))

Use the Formula

• Then, you have to Hit the Enter key to get the result in the cell C5 as shown below.

Result for the cell C5

• Now, you need to press Ctrl+D key to get the results in all other columns.

Output

Check this too:

• Excel Formulas to convert Celsius to Fahrenheit in Excel!!
• Formulas for Converting Days to Years, Months, and Days!!

Closure

Here, we have explained the step-by-step procedure to ** convert the column letter to number in Excel** with the examples. Make use of this. Please share your worthwhile feedback in the below comment section. To learn more, check out our website Geek Excel!!

Read Next:

• Convert Column Number to Letter in Excel ~ Different Ways!!
• How To Return Column Letter for column number In Microsoft Excel?
• Excel Formulas to Capitalize the First Letter of a Text String!!
• How to Convert Text String to Formula in Excel Office 365?
• How to Add the Same Text or Characters in a Range of Cells in Excel 365?