## Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

• Help others & share knowledge
• Earn cash & points
Solved

# Auto input column letter headings for columns > "Z" in Excel

Posted on 2011-03-13
459 Views
Hello,

In Excel (2007), I have been using the following formula to generate letters (rather than numbers) to represent particular columns:

=UPPER(CHAR(COLUMN(A1)+96))

However, that method is only useful for columns A-Z.  Beginning with column AA, the formula returns non-alphabetic symbols.

Is there a different formula which generates column letters but does so for all columns rather than just the first 26?

Thanks
0
• 4
• 2
• 2

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 500 total points
ID: 35123540
The formula below returns the column letter or letters given a column number.

Kevin
0

LVL 81

Expert Comment

ID: 35123558
In case the row the formula is in is not row 1:

Kevin
0

LVL 12

Expert Comment

ID: 35123559

Try this:

for the column it is entered in,

OR

for the column of E5.

HTH,

Alan.
0

LVL 12

Expert Comment

ID: 35123561
Sorry, that last narrative should have read AC5.

Just change the reference in the formula as required.

Alan.
0

LVL 12

Expert Comment

ID: 35123568
However, can I ask *why* you want this?

I suspect there is a much easier way to achieve your actual objective, that going down this route.

Alan.
0

Author Comment

ID: 35123814
Thank you for the helpful responses.

Alan3285:
>>I suspect there is a much easier way to achieve your actual objective, that going down this route.

Alan, I appreciate that follow-up question and I would like to see if there is an easier way to approach it. However, since the question in this thread has already been answered, I will begin a new thread in a few minutes with the follow-up question there.

Thanks again.
0

LVL 12

Expert Comment

ID: 35123897
Okay - no problem.

Alan.
0

Author Comment

ID: 36358811
Reference file added with a couple of methods.
EE-26883770-Auto-input-column-le.xlsx
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.