Skip to content

Instantly share code, notes, and snippets.

@thomaslarsen

thomaslarsen/gist:5ba7ef6f3cfc72313231

Created June 17, 2015 10:44
Show Gist options
  • Save thomaslarsen/5ba7ef6f3cfc72313231 to your computer and use it in GitHub Desktop.
Save thomaslarsen/5ba7ef6f3cfc72313231 to your computer and use it in GitHub Desktop.
Download ZIP
Excel formula to generate the column name in a cell
Raw
gistfile1.txt
=IF(COLUMN()>26,CHAR(INT((COLUMN()-1)/26)+64),"")&CHAR(MOD(COLUMN()-1,26)+65)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment