Column
 

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.

Column
 

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.

Column
 

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

--
Jacob


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

Column
 

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
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Alan" wrote in message
...
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.

Column
 

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.