=SUBSTITUTE(ADDRESS(1,COLUMN(INDIRECT($C1&1))+{3,5},4),1,)