Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
Does anyone have any suggestions on how to display the column name?
For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
What is the purpose and how far do you want to go left and down on the sheet
with those names? Argy "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
I get a formula under column AC, INDIRECT("AC"&591+1) in cell AC593.
When I copy this cell to the right under column AD, the character does not change as I copy this cells into another location. does anyone have any suggestions on how to display the column within Indirect function? Does anyone have any suggestions? Thanks in advance for any suggestions Eric "Argy - Arcasoft" wrote: What is the purpose and how far do you want to go left and down on the sheet with those names? Argy "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
This is what responded to your question below;
Use this in cell AC593 =INDIRECT("R591C"&COLUMN(),FALSE) + 1 and copy across This will add 1 to AC591 "Eric" wrote: I get a formula under column AC, INDIRECT("AC"&591+1) in cell AC593. When I copy this cell to the right under column AD, the character does not change as I copy this cells into another location. does anyone have any suggestions on how to display the column within Indirect function? Does anyone have any suggestions? Thanks in advance for any suggestions Eric "Argy - Arcasoft" wrote: What is the purpose and how far do you want to go left and down on the sheet with those names? Argy "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
You can have numbers 1-whatever in Col of Sheet2 and A-Z,AB-AZ in Col B
and use this in A1 Sheet 1 and copy across Row1 =VLOOKUP(Column(),Sheet2!$A:$B,2,False) in "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
take this:
=SUBSTITUTE(CELL("address",A1),"$","") put his on cell a1, copy it to anywhere and it will work accordingly. no fuss no mess -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
Thank everyone very much for any suggestions
Could you please tell me how to remove numbers and keep characters only? Thank you very much for any suggestions Eric "Satti Charvak" wrote: take this: =SUBSTITUTE(CELL("address",A1),"$","") put his on cell a1, copy it to anywhere and it will work accordingly. no fuss no mess -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
=SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","")
Will remove the both the $ and the 1. Eric wrote: Thank everyone very much for any suggestions Could you please tell me how to remove numbers and keep characters only? Thank you very much for any suggestions Eric "Satti Charvak" wrote: take this: =SUBSTITUTE(CELL("address",A1),"$","") put his on cell a1, copy it to anywhere and it will work accordingly. no fuss no mess -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
Thank everyone for any suggestions
What about 0-9 numbers? there is a limitation to use a number of () within Excel. Do you have any suggestions? Thank everyone very much for any suggestions Eric "Dave Peterson" wrote: =SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","") Will remove the both the $ and the 1. Eric wrote: Thank everyone very much for any suggestions Could you please tell me how to remove numbers and keep characters only? Thank you very much for any suggestions Eric "Satti Charvak" wrote: take this: =SUBSTITUTE(CELL("address",A1),"$","") put his on cell a1, copy it to anywhere and it will work accordingly. no fuss no mess -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display the column name?
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),1,"") is a shorter version, and will
display the column number only. What do you mean the 0-9 numbers, what are you trying to accomplish? -- ** John C ** "Eric" wrote: Thank everyone for any suggestions What about 0-9 numbers? there is a limitation to use a number of () within Excel. Do you have any suggestions? Thank everyone very much for any suggestions Eric "Dave Peterson" wrote: =SUBSTITUTE(SUBSTITUTE(CELL("address",A1),"$",""), "1","") Will remove the both the $ and the 1. Eric wrote: Thank everyone very much for any suggestions Could you please tell me how to remove numbers and keep characters only? Thank you very much for any suggestions Eric "Satti Charvak" wrote: take this: =SUBSTITUTE(CELL("address",A1),"$","") put his on cell a1, copy it to anywhere and it will work accordingly. no fuss no mess -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Eric" wrote: Does anyone have any suggestions on how to display the column name? For example, under column AB, I would like to display "AB" in cell AB1 Does anyone have any suggestions? Thanks in advance for any suggestions Eric -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
Row & Column Header Display | Excel Discussion (Misc queries) | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
find value in column F, then display value in column A of that row | Excel Worksheet Functions |