Formula for column / heading

[qibla]

Hi guys thanks for all the help.
What formula do i use so the result is the column... for example for column C only C must be the result. Hope that makes sense ... thanks

[teylyn]

Hi,

try

Please Login or Register  to view this content.

[DonkeyOte]

Or

=SUBSTITUTE(ADDRESS(1,COLUMN(),2),"$1","")

[qibla]

Thanks so much.

[teylyn]

@DonQ

I knew I'd learn something from you today.