Column

[Alan]

Apologies if there is a really obvious answer to this but it is driving me
mad! When you use the column() function you get the number of the column
(i.e. column (E) = 5; is there a way I can get the actual column (i.e. 'E')?

Many thanks,

Alan.

 

[ryguy7272]

Try this in Cell E1:
=LEFT(ADDRESS(1,COLUMN(),4),1)

 

[Jacob Skaria]

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

 

[Bernard Liengme]

Hope someone give you a shorter formula but her is my offering
=MID(ADDRESS(ROW(),COLUMN(),2),1,FIND("$",ADDRESS(ROW(),COLUMN(),2))-1)
best wishes

 

[Teethless mama]

This formula will work from A-Z

=CHAR(64+COLUMN())