column heading formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
=LEFT(ADDRESS(1,COLUMN(),4,1),IF(COLUMN()<27,1,2))

Regards,
Stefi


„EricBB†ezt írta:
 
You are absolutely right! Didn't think enough:-)

carlo said:
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
Click to expand...
 
@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 :D

Cheers Carlo
 
Hi Eric

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

this will deal with all column headings up to XFD in Excel 2007
 
all your answer got the same result, which really what im looking for. thank
you guys.
EricBB
 
Back
Top