View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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","")