|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 17th, 2009, 04:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
December 17th, 2009, 04:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#3
December 17th, 2009, 04:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#4
December 17th, 2009, 04:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#5
December 17th, 2009, 06:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
