Function to return Column

[SIGE]

Hi all,

Looking for a function that can return it's column value.

eg. if I am at cell "S5" and enter the Column() function it will return me ... 19.

I am looking for a function that can actually return me "S" instead of "19"

Anyone who can help?

Thanks in advance,
Sige

 

[T. Valko]

Hi all,

Looking for a function that can return it's column value.

eg. if I am at cell "S5" and enter the Column() function it will return me ... 19.

I am looking for a function that can actually return me "S" instead of "19"

Anyone who can help?

Thanks in advance,
Sige

Try this...

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

 

[VoG]

For columns up to Z try

=CHAR(COLUMN()+64)

 

[Andrew Poulsom]

One way:

=LEFT(ADDRESS(1,COLUMN(S1),4),FIND(1,ADDRESS(1,COLUMN(S1),4))-1)

 

[SIGE]

Thx All!

Taking style and flexibility into consideration I'll settle for Valko's solution!
Thx again!
Sige

 

[T. Valko]

Thx All!

Taking style and flexibility into consideration I'll settle for Valko's solution!
Thx again!
Sige

You made a wise choice!

Thanks for the feedback!