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



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Alan" wrote:

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.