column heading formula
 

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

column heading formula
 

here we go:

=CHAR(COLUMN()+64)

greetings

"EricBB" schreef in bericht
...
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

column heading formula
 

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

hth

Carlo

On Nov 15, 4:26 pm, EricBB wrote:
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

column heading formula
 

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

On Nov 15, 4:37 pm, "Frederik" wrote:
here we go:

=CHAR(COLUMN()+64)

greetings

"EricBB" schreef in ...



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- Hide quoted text -

- Show quoted text -

column heading formula
 

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

Regards,
Stefi


€žEricBB€� ezt Ã*rta:

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

column heading formula
 

You are absolutely right! Didn't think enough:-)

"carlo" schreef in bericht
...
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

On Nov 15, 4:37 pm, "Frederik" wrote:
here we go:

=CHAR(COLUMN()+64)

greetings

"EricBB" schreef in
...



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- Hide quoted text -

- Show quoted text -

column heading formula
 

@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


On Nov 15, 4:45 pm, Stefi wrote:
=LEFT(ADDRESS(1,COLUMN(),4,1),IF(COLUMN()<27,1,2))

Regards,
Stefi

„EricBB" ezt írta:



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- Hide quoted text -

- Show quoted text -

column heading formula
 

Hi Eric

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

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

--
Regards
Roger Govier



"EricBB" wrote in message
...
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

column heading formula
 

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

"Roger Govier" wrote:

Hi Eric

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

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

--
Regards
Roger Govier



"EricBB" wrote in message
...
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