How can I change column numbers back to column letters?

S

Space Elf

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?
 
Î

ΓΙΑÎÎΗΣ Χ.Î’.

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
 
Top