Thread
:
CHAR funtcion with double letter columns
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_]
external usenet poster
Posts: 1,231
CHAR funtcion with double letter columns
"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","")
Reply With Quote
Harlan Grove[_2_]
View Public Profile
Find all posts by Harlan Grove[_2_]