CHAR funtcion with double letter columns
Hi Ellen,
Maybe a better way but this should work
=LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN() ,4))-1)
HTH
Martin
"ellebelle" wrote in message
...
I am using this function:
CHAR(MATCH(P$1,$1:$1,)+64)
to get teh column letter, however it does not count double letters past
column z. As in AA AB etc.
Is there a way to get this?
Ellen
|