# How to Change the Name of an Excel Column from Numerical to Alphabetical (2 Ways)

To demonstrate the methods, weâ€™ll use the following dataset representing some productsâ€™ prices. The column names are in numerical order.

### Method 1 – Unmark R1C1 Reference StyleÂ

Steps:

• Click the File option beside the HomeÂ tab.

• Click on Options.
• And a dialog box will open up.

• From the Formulas section, unmark the R1C1 reference style.
• Press OK.

Excel has changed the column name from number to the default alphabet system.

### Method 2 – Use Excel Formula to ConvertÂ

#### 2.1 Use the CHAR Function for Single-Letter Columns

Steps:

• Enter the following formula in cell C5:
`=CHAR(64+B5)`
• Press the Enter button to get the output.

• Drag the Fill Handle icon to copy the formula for the other cells.

You will get all the column names in alphabetical order.

#### 2.2 Use SUBSTITUTE and ADDRESS Functions for Any Column

Steps:

• Enter the following formula in cell C5:
`=SUBSTITUTE(ADDRESS(1,B5, 4), "1", "")`
• Press the Enter button to get the corresponding alphabet.

• Use the Fill Handle tool to copy the formula.

We have all the column names in the alphabet according to my given column numbers.

Formula Breakdown:

The ADDRESS function will return the cell reference according to row number 1 and column number 1. So it will return as
“A1”

The SUBSTITUTE function will replace the row number with empty from the reference and will return as-
“A”

Read More: How to Title a Column in Excel

## Manually Change Excel Column Name from Number to Alphabet

Steps:

• Enter 1 in cell A1.

• EnterÂ the following formula in cell B1:
`=A1+1`
• Press the EnterÂ button.

• Drag the Fill Handle icon in the right direction to get the other column numbers.

I dragged until Column E.

## Related Articles

<< Go Back to Rows and Columns Headings | Rows and Columns in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF