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