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?

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
__

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?

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?