View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default 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","")