How to get the alphabetical reference of a cell

[Guest]

Hi,

I am a newbie to excel/macro development.

I wanted to know how to get the alphabetical reference of a column based on
a cell. For example, the formula =Column(C2) gives me the value of 3. But i
need to get 'C' instead of 3. May I know how to go about getting 'C' using an
excel formula?

Thanks

 

[Dave Peterson]

One way:
=SUBSTITUTE(ADDRESS(1,COLUMN(C2),4,TRUE),"1","")

 

[Kurt]

check out the "CHAR" function.

 

[Pete_UK]

The CHAR function would only return a single character - okay if you
are only using columns A to Z. Dave's formula returns "AA" when copied
from C2 into AA2 - thanks for this, Dave.

Pete

 

[Zoddy]

You could also use

=CHAR(COLUMN(C2)+64)