Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I change column numbers back to column letters?
I'm using Office 2000. The columns are normally letters. When using the
command COLUMN(CB7), naturally I get the answer "80". How can I convert it back to "CB"? Someting like COMMAND(80) will equal "CB". I can't use CHAR(64+80) because that would not result in multiple letter column. Any help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I change column numbers back to column letters?
On Thu, 2 Mar 2006 08:40:06 -0800, Space Elf
wrote: I'm using Office 2000. The columns are normally letters. When using the command COLUMN(CB7), naturally I get the answer "80". How can I convert it back to "CB"? Someting like COMMAND(80) will equal "CB". I can't use CHAR(64+80) because that would not result in multiple letter column. Any help? The following entered in any cell will return the column reference of that cells column. =LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN() ,4))-1) A slight modification to include the specific column reference, e.g CB7 will produce "CB" wherever the formula is placed. =LEFT(ADDRESS(1,COLUMN(CB7),4),LEN(ADDRESS(1,COLUM N(CB7),4))-1) Hope this helps Richard Buttrey __ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I change column numbers back to column letters?
=MID(ADDRESS(1,COLUMN()),2,FIND("$",ADDRESS(1,COLU MN()),2)-2)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Space Elf" wrote in message ... I'm using Office 2000. The columns are normally letters. When using the command COLUMN(CB7), naturally I get the answer "80". How can I convert it back to "CB"? Someting like COMMAND(80) will equal "CB". I can't use CHAR(64+80) because that would not result in multiple letter column. Any help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I change column numbers back to column letters?
Another simple solution:
=LEFT(ADDRESS(1,COLUMN(),4),IF(COLUMN()<27,1,2)) =LEFT(ADDRESS(1,COLUMN(CB7),4),IF(COLUMN(CB7)<27,1 ,2)) Ioannis, Athens "Space Elf" wrote: I'm using Office 2000. The columns are normally letters. When using the command COLUMN(CB7), naturally I get the answer "80". How can I convert it back to "CB"? Someting like COMMAND(80) will equal "CB". I can't use CHAR(64+80) because that would not result in multiple letter column. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Excel column headings were letters and it switched to numbers? | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters? | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
how do i change column labels back to letters? currently columns. | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) |