This formula will work from A-Z

=CHAR(64+COLUMN())


"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.