column heading formula

[Guest]

i'm in column A, i type this formula in a cell , cell("col") then it gives a
result of 1. my problem is what formula should i type to get a result of A
(column heading)? appreciate any help.

EricBB

 

[Frederik]

here we go:

=CHAR(COLUMN()+64)

greetings

 

[carlo]

=LEFT(ADDRESS(ROW(),COLUMN(),4),LEN(ADDRESS(ROW(),COLUMN(),4))-
LEN(ROW()))

hth

Carlo

 

[carlo]

Unfortunately Frederiks Formula only works for the first 26 columns!
If you don't need more than that, it works perfect. Otherwise take my
Formula.

Cheers Carlo

 

[Guest]

=LEFT(ADDRESS(1,COLUMN(),4,1),IF(COLUMN()<27,1,2))

Regards,
Stefi


„EricBB†ezt írta:

 

[Frederik]

You are absolutely right! Didn't think enough

Unfortunately Frederiks Formula only works for the first 26 columns!
If you don't need more than that, it works perfect. Otherwise take my
Formula.

Cheers Carlo

 

[carlo]

@Stefi...Thanks for the shorter version Stefi, didn't came to my mind.

@EricBB...go with Stefis version.

@frederik....i know...i always had that problem with columns

Cheers Carlo

 

[Roger Govier]

Hi Eric

Try
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")

this will deal with all column headings up to XFD in Excel 2007

 

[Guest]

all your answer got the same result, which really what im looking for. thank
you guys.
EricBB