Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
=IF(COLUMN()>26,CHAR(INT((COLUMN()-1)/26)+64)&CHAR(MOD(COLUMN(),26)+64),CHAR(COLUMN()+64))
=IF(COLUMN()>26,CHAR(INT((COLUMN()-1)/26)+64)&CHAR(MOD(COLUMN()-1,26)+65),CHAR(COLUMN()+64))
Function ColLetters()
with activecell
if .column > 26 then
ColLetters = Chr(Int((.column-1)/26)+64) & _
Chr((.column-1) MOD 26)+65)
else
Chr(.column+ 64)
end if
end with
End Function