CHAR funtcion with double letter columns
Hi Harlan,
I used to count lateral thinking as one of my talents.
These newsgroups soon knocked that nonsense out of my head. <g
Regards
Martin
"Harlan Grove" wrote in message
...
"MartinW" wrote...
Maybe a better way but this should work
=LEFT(ADDRESS(1,COLUMN(),4),LEN(ADDRESS(1,COLUMN (),4))-1)
...
Could be shorter.
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")
|